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

Re: Need help in setting optimal configuration for a huge

From: "Karl O(dot) Pinc" <kop(at)meme(dot)com>
To: Kishore B <kishorebh(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Need help in setting optimal configuration for a huge
Date: 2005-10-22 22:03:03
Message-ID: 1130018583l.27845l.10l@mofo (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-performance
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(at)meme(dot)com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein


In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2005-10-22 22:15:43
Subject: Re: Need help in setting optimal configuration for a huge database.
Previous:From: Steinar H. GundersonDate: 2005-10-22 21:57:49
Subject: Re: Need help in setting optimal configuration for a huge database.

pgsql-admin by date

Next:From: Kirby UbbenDate: 2005-10-22 22:04:19
Subject: Pgpool errors: pgpool 2.6.4 postgres 7.3.10 ProcessFrontendResponse: failed to read kind from frontend. fronend abnormally exited
Previous:From: Steinar H. GundersonDate: 2005-10-22 21:57:49
Subject: Re: Need help in setting optimal configuration for a huge database.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group