Skip site navigation (1) Skip section navigation (2)

Re: PERFORMANCE meeting summary & next meeting topic!

From: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
To: Selena Deckelmann <selena(at)chrisking(dot)com>
Cc: pdxpug(at)postgresql(dot)org
Subject: Re: PERFORMANCE meeting summary & next meeting topic!
Date: 2006-09-20 17:29:31
Message-ID: A5A0EB6F-DCF6-480D-8D52-6775BD5AFEB2@kineticode.com (view raw or flat)
Thread:
Lists: pdxpug
On Sep 20, 2006, at 09:03, Selena Deckelmann wrote:

> The general consensus was that she should upgrade.  We didn't have  
> a clear answer to why the query was so slow in the older version,  
> but it was clear that it was faster in the newer version of  
> postgresql.

Actually, I think that the consensus was that she should try  
increasing the sort_mem on the 7.4 database to see if that helps. But  
upgrading is a no-brainer, too. :-)

Thanks for a fun meeting, all!

Best,

David

In response to

Responses

pdxpug by date

Next:From: Randal L. SchwartzDate: 2006-09-20 17:33:31
Subject: Re: PERFORMANCE meeting summary & next meeting topic!
Previous:From: Selena DeckelmannDate: 2006-09-20 16:03:16
Subject: PERFORMANCE meeting summary & next meeting topic!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group