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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: PERFORMANCE meeting summary & next meeting topic!


  • From: Selena Deckelmann <selena(at)chrisking(dot)com>
  • To: pdxpug(at)postgresql(dot)org
  • Subject: Re: PERFORMANCE meeting summary & next meeting topic!
  • Date: Wed, 20 Sep 2006 10:53:25 -0700
  • Message-id: <3caa6e8d47fb20ae63db2d13025fb28a(at)chrisking(dot)com>


On Sep 20, 2006, at 10:29 AM, David E. Wheeler wrote:

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

Oh, right!  I remember that now.  Thanks!

happy to be in consensus for real this time,
-selena




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group