| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Glenn Sullivan <glenn(dot)sullivan(at)varianinc(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: shared buffers |
| Date: | 2004-10-25 21:08:49 |
| Message-ID: | 28074.1098738529@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Glenn Sullivan <glenn(dot)sullivan(at)varianinc(dot)com> writes:
> What is the performance issue with setting shared_buffers to something like 45?
> In doing some timing on my system, I cannot tell any difference with 45 versus 1000.
What are you timing exactly? Almost every benchmark I've ever seen is
much happier with shared_buffers of at least a few hundred. Otherwise
you spend too much time copying data between kernel and user space.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gaetano Mendola | 2004-10-25 21:42:17 | Re: PgSQL MVCC vs MySQL InnoDB |
| Previous Message | Gaetano Mendola | 2004-10-25 20:58:26 | Re: (S)RPMs for PostgreSQL 7.2.6, 7.3.8 and 7.4.6 are ready |