On Thu, Dec 28, 2006 at 10:35:29PM -0500, Dave Cramer wrote:
> start with 25% of your 12G as shared buffers, and 75% of 12G for
> effective cache
I'm curious... why leave 3G for the kernel? Seems like overkill...
Granted, as long as you're in the ballpark on effective_cache_size
that's all that
Hi,
On 28-Dec-06, at 8:58 PM, fabrix peñuelas wrote:
Good day,
I have been reading about the configuration of postgresql, but I
have a server who does not give me the performance that should. The
tables are indexed and made vacuum regularly, i monitor with top,
ps and pg_stat_activity an
What are your table sizes? What are your queries like? (Mostly read,
mostly write?)
Can you post the "analyze" output for some of the slow queries?
The three things that stand out for me is your disk configuration (RAID
5 is not ideal for databases,
you really want RAID 1 or 1+0) and also tha
