limiting postgresql

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

On Mon, Apr 21, 2008 at 11:13 AM, Kyle Waters <unum at> 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.


More information about the PLUG mailing list