| From: | "P(dot)J(dot) \"Josh\" Rovero" <rovero(at)sonalysts(dot)com> |
|---|---|
| To: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
| Cc: | PostgreSQL general list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Solaris and effective_cache_size |
| Date: | 2002-02-15 17:27:26 |
| Message-ID: | 3C6D44FE.8020508@sonalysts.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)sonalysts(dot)com www.sonalysts.com 215 Parkway North
Work: (860)326-3671 or 442-4355 Waterford CT 06385
***********************************************************************
| From | Date | Subject | |
|---|---|---|---|
| Next Message | david blood | 2002-02-15 17:27:34 | current connections and queries |
| Previous Message | Andy Marden | 2002-02-15 17:20:28 | User access to start and stop postmaster |