| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kirby Ubben | 2005-10-22 22:04:19 | Pgpool errors: pgpool 2.6.4 postgres 7.3.10 ProcessFrontendResponse: failed to read kind from frontend. fronend abnormally exited |
| Previous Message | Steinar H. Gunderson | 2005-10-22 21:57:49 | Re: Need help in setting optimal configuration for a huge database. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-10-22 22:15:43 | Re: Need help in setting optimal configuration for a huge database. |
| Previous Message | Steinar H. Gunderson | 2005-10-22 21:57:49 | Re: Need help in setting optimal configuration for a huge database. |