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 /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
