From: | Chris Dunn <chris(dot)dunn(at)bigredsky(dot)com> |
---|---|
To: | "'pgsql-performance(at)postgresql(dot)org'" <pgsql-performance(at)postgresql(dot)org> |
Subject: | FW: Performance 8.4.0 |
Date: | 2009-08-03 02:04:22 |
Message-ID: | 9DD841FFB22DB8468E2AF1F1CA3844E8B0FC9775EA@brs-exchange.BigRedSky.corp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
The database is 8gb currently. Use to be a lot bigger but we removed all large objects out and developed a file server storage for it, and using default page costs for 8.4, I did have it changed in 8.1.4
-----Original Message-----
From: Robert Haas [mailto:robertmhaas(at)gmail(dot)com]
Sent: Sunday, 2 August 2009 11:26 PM
To: Chris Dunn
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] Performance 8.4.0
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
From | Date | Subject | |
---|---|---|---|
Next Message | Chris | 2009-08-03 02:04:58 | Re: Greenplum MapReduce |
Previous Message | Euler Taveira de Oliveira | 2009-08-02 20:55:29 | Re: Why is PostgreSQL so slow on Windows ( Postgres 8.3.7) version |