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