Re: Performance 8.4.0

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Chris Dunn <chris(dot)dunn(at)bigredsky(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Performance 8.4.0
Date: 2009-08-02 15:25:30
Message-ID: 603c8f070908020825w6a112ec8q8bdde36504a3682d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Jul 31, 2009 at 12:22 AM, Chris Dunn<chris(dot)dunn(at)bigredsky(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Adam PAPAI 2009-08-02 16:28:37 select count(idn) is slow (Seq Scan) instead of Bitmap Heap.. why?
Previous Message Dimitri Fontaine 2009-08-01 15:57:04 Re: load / stress testing