Re: Finding bottleneck

From: Claus Guttesen <kometen(at)gmail(dot)com>
To: Kari Lavikka <tuner(at)bdb(dot)fi>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Finding bottleneck
Date: 2005-07-28 11:52:03
Message-ID: b41c75520507280452751f40f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> effective_cache_size = 1000000 # typically 8KB each

I have this setting on postgresql 7.4.8 on FreeBSD with 4 GB RAM:

effective_cache_size = 27462

So eventhough your machine runs Debian and you have four times as much
RAM as mine your effective_cache_size is 36 times larger. You could
try lowering this setting.

regards
Claus

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2005-07-28 12:20:35 Re: Performance problems testing with Spamassassin 3.1.0 Bayes module.
Previous Message Greg Stark 2005-07-28 11:49:29 Re: wal_buffer tests in