| From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
|---|---|
| To: | matthew(at)zeut(dot)net |
| Cc: | pgsql-hackers(at)postgresql(dot)org, tgl(at)sss(dot)pgh(dot)pa(dot)us |
| Subject: | Re: Changing the default configuration |
| Date: | 2003-02-12 01:10:26 |
| Message-ID: | 20030212.101026.71083976.t-ishii@sra.co.jp |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-advocacy pgsql-hackers pgsql-performance |
It's interesting that people focus on shared_buffers. From my
experience the most dominating parameter for performance is
wal_sync_method. It sometimes makes ~20% performance difference. On
the otherhand, shared_buffers does very little for
performance. Moreover too many shared_buffers cause performance
degration! I guess this is due to the poor design of bufmgr. Until it
is fixed, just increasing the number of shared_buffers a bit, say
1024, is enough IMHO.
--
Tatsuo Ishii
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2003-02-12 01:23:28 | Re: Changing the default configuration |
| Previous Message | Tatsuo Ishii | 2003-02-12 01:10:08 | Re: Changing the default configuration |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2003-02-12 01:23:28 | Re: Changing the default configuration |
| Previous Message | Tatsuo Ishii | 2003-02-12 01:10:08 | Re: Changing the default configuration |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2003-02-12 01:23:28 | Re: Changing the default configuration |
| Previous Message | Tatsuo Ishii | 2003-02-12 01:10:08 | Re: Changing the default configuration |