| From: | Hilary Forbes <hforbes(at)dmr(dot)co(dot)uk> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Version 7 question |
| Date: | 2003-07-01 12:10:08 |
| Message-ID: | 5.1.0.14.0.20030701125931.02040fa0@mailserver.ipl.co.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
I'm just trying to improve performance on version 7 before doing some tests and hopefully upgrading to 7.3.
At the moment we have
B=64 (no of shared buffers)
N=32 (no of connections)
in postmaster.opt which I take it is the equivalent of the new postgresql.conf file.
From all that is being written about later versions I suspect that this is far too low. Would I be fairly safe in making the no of shared buffers larger? Also is there an equivalent of effective_cache_size that I can set for version 7?
Many thanks in advance
Hilary
Hilary Forbes
-------------
DMR Computer Limited: http://www.dmr.co.uk/
Direct line: 01689 889950
Switchboard: (44) 1689 860000 Fax: (44) 1689 860330
E-mail: hforbes(at)dmr(dot)co(dot)uk
**********************************************************
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Mattox | 2003-07-01 12:17:08 | Re: Version 7 question |
| Previous Message | Shridhar Daithankar | 2003-07-01 08:17:06 | Re: slower with the time |