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
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 and when i checked was slow without a heavy load overage.
B
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
TECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of fabrix
peñuelas
Sent: Thursday, December 28, 2006 7:58 PM
To: pgsql-performance@postgresql.org
Subject: [PERFORM] Postgresql Configutation and overflow
Good day,
I have been reading about the configuration of postgresql, but I have a
server who d
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 and when i checked was slow without a heavy load overage.
Befor
