Andrew Sullivan wrote:
> On Fri, Feb 15, 2002 at 11:17:42AM -0500, Tom Lane wrote:
>
>>However, I'm quite surprised to hear that tweaking effective_cache_size
>>affects pgbench results at all. I'd have thought that all the queries
>>used by pgbench would be indexscans anyway...
>>
>
> I was sort of surprised by that, too. But the effect is totally
> consistent over dozens of tests.
pgbench does a bunch of updates, which generate WAL activity.
At some point it goes to disk. I keep increasing the number
of transactions in pgbench, eventually it'll go to disk.
--
P. J. "Josh" Rovero Sonalysts, Inc.
Email: rovero@sonalysts.com www.sonalysts.com 215 Parkway North
Work: (860)326-3671 or 442-4355 Waterford CT 06385
***********************************************************************
