On Mon, Apr 21, 2008 at 11:13 AM, Kyle Waters <[EMAIL PROTECTED]> 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 /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
