| From: | Mark Rae <mrae(at)purplebat(dot)com> |
|---|---|
| To: | William Yu <wyu(at)talisys(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL on Dual Processors, Dual-Core AMD Chips |
| Date: | 2005-10-19 18:45:51 |
| Message-ID: | 20051019184551.GA5648@purplebat.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Oct 19, 2005 at 09:55:18AM -0700, William Yu wrote:
> Mark Rae wrote:
> >With the newer kernels you should find that a dual core will
> >be giving you about 80% increase over a single core.
>
> I'm not experiencing this problem right now because I have NUMA disabled
> in the BIOS. :)
That is the recommended 'fix' :-D
> I'm not sure NUMA will help that much for Postgres due
> to Postgres shared memory + OS caching architecture --
The 80% figure is for general data processing code. I actually got
a 72% performance increase using postgres for read only queries.
I would think that any write activity would still be limited by
how fast you can write the WAL to disk.
-Mark
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dann Corbit | 2005-10-19 18:53:56 | Re: Select all invalid e-mail addresses |
| Previous Message | Marc G. Fournier | 2005-10-19 18:40:44 | Re: [pgsql-advocacy] Oracle buys Innobase |