Postgres Pro
Downloads
Home   >   mailing lists

Re: Finding bottleneck - Mailing list pgsql-performance

From Claus Guttesen
Subject Re: Finding bottleneck
Date
Msg-id b41c75520507280452751f40f@mail.gmail.com
Whole thread Raw
In response to Finding bottleneck  (Kari Lavikka <tuner@bdb.fi>)
List pgsql-performance
Tree view 
> 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

pgsql-performance by date:

Previous
From: Gnanavel S
Date:
Subject: Re: Left joining against two empty tables makes a query SLOW
Next
From: "Merlin Moncure"
Date:
Subject: Re: Performance problems testing with Spamassassin 3.1.0 Bayes module.