Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance 8.4.0 - Mailing list pgsql-performance

From Robert Haas
Subject Re: Performance 8.4.0
Date
Msg-id 603c8f070908020825w6a112ec8q8bdde36504a3682d@mail.gmail.com
Whole thread Raw
In response to Performance 8.4.0  (Chris Dunn <chris.dunn@bigredsky.com>)
Responses Re: Performance 8.4.0
List pgsql-performance
Tree view 
On Fri, Jul 31, 2009 at 12:22 AM, Chris Dunn<chris.dunn@bigredsky.com> wrote:
> constraint_exclusion = on

This is critical if you need it, but a waste of CPU time if you don't.
 Other than that your paramaters look good.  Are you using the default
page cost settings?  I see you have 12 GB RAM; how big is your
database?

...Robert

pgsql-performance by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: load / stress testing
Next
From: Adam PAPAI
Date:
Subject: select count(idn) is slow (Seq Scan) instead of Bitmap Heap.. why?