Re: Solaris and effective_cache_size

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
***********************************************************************