Re: More shared buffers causes lower performances

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: "Greg Smith" <gsmith(at)gregsmith(dot)com>
Cc: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>, "pgsql-performance" <pgsql-performance(at)postgresql(dot)org>, "Stefan Kaltenbrunner" <stefan(at)kaltenbrunner(dot)cc>, Devrim GÜNDÜZ <devrim(at)commandprompt(dot)com>
Subject: Re: More shared buffers causes lower performances
Date: 2007-12-27 16:42:44
Message-ID: 87bq8cw0l7.fsf@oxford.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Greg Smith" <gsmith(at)gregsmith(dot)com> writes:

> The worst time people can run into a performance
> regression is when they're running a popular benchmarking tool.

Hm, perhaps pg_bench should do a "show debug_assertions" and print a warning
if the answer isn't "off". We could encourage other benchmark software to do
something similar.

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's RemoteDBA services!

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Alvaro Herrera 2007-12-27 16:50:46 Re: More shared buffers causes lower performances
Previous Message Vivek Khera 2007-12-27 16:26:58 Re: With 4 disks should I go for RAID 5 or RAID 10