limiting postgresql

Kyle Waters unum at unum5.org
Mon Apr 21 11:13:58 MDT 2008


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 :).

Kyle



More information about the PLUG mailing list