Postgres Pro
Downloads
Home   >   mailing lists

Re: Need help in setting optimal configuration for a huge - Mailing list pgsql-performance

From Karl O. Pinc
Subject Re: Need help in setting optimal configuration for a huge
Date
Msg-id 1130018583l.27845l.10l@mofo
Whole thread Raw
In response to Need help in setting optimal configuration for a huge database.  (Kishore B <kishorebh@gmail.com>)
List pgsql-performance
Tree view 
On 10/22/2005 04:15:25 PM, Kishore B wrote:

> Can any you please suggest the best configuration to satisfy the above
> requirements?

You've increased shared memory buffers, told the kernel
to allow more shared memory (lots), and otherwise increased
the parameters associated with memory?

If so you might want to post the relevant configs
here.

If the basic tuning does not help enough you may
want to upgrade to 8.0 as it has significant
performance improvements.

Karl <kop@meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein

pgsql-performance by date:

Previous
From: "Steinar H. Gunderson"
Date:
Subject: Re: Need help in setting optimal configuration for a huge database.
Next
From: "Steinar H. Gunderson"
Date:
Subject: Re: Need help in setting optimal configuration for a huge database.