limiting postgresql

Dennis Muhlestein devel at muhlesteins.com
Mon Apr 21 11:39:33 MDT 2008


On Mon, Apr 21, 2008 at 11:13 AM, Kyle Waters <unum at unum5.org> wrote:
> Dennis Muhlestein wrote:
>
> >
> > Have you spent much time on the cpu intensive task?  It seems suspect
> > to me to have a db task taking up that much cpu.  There are some
> > settings in the postgresql.conf file for tuning the amount of memory
> > available for queries, connections, and certain operations.  I don't
> > know if any of those can be done on a per-connection basis though.
> > Either way, it may be possible to rewrite your cpu intensive queries
> > to be less intrusive.
> >
> >
> >
>
>  Ya. I'm trying to figure out how to do that.  I have 4 different summations
> I have to perform on tens of thousands of lines, and I'm afraid I'm not very
> good at sql :).
>

You could always post the query.  Or post it to udbug.  Also, the
postgresql mailing lists (also available over nntp) have been
extremely helpful in debugging slow queries and performance issues in
the past.

-Dennis



More information about the PLUG mailing list