Tom Lane wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > Also if autovacuum is eating all your I/O you may want to look into
> > throttling it back a bit by setting autovacuum_vacuum_cost_delay to a
> > non-zero value.
>
> BTW, why is it that autovacuum_cost_delay isn't enabled by default?
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Also if autovacuum is eating all your I/O you may want to look into
> throttling it back a bit by setting autovacuum_vacuum_cost_delay to a
> non-zero value.
BTW, why is it that autovacuum_cost_delay isn't enabled by default?
I can hardly believe that a
On Thu, 7 Jun 2007, Joe Lester wrote:
Memory: 4GB RAM
shared_buffers = 1
work_mem = 2048
effective_cache_size = 3
With these parameters, your server has 80MB dedicated to its internal
caching, is making query decisions assuming the operating system only has
240MB of memory available
Joe Lester wrote:
> max_fsm_pages = 15
This may be a bit too low -- it's just a little more than 1 GB, which
means it might fail to keep track of all your tables (or it may not, if
you don't have many updates).
> autovacuum_naptime = 60
> autovacuum_vacuum_threshold = 150
> autovacuum_vacuum
On Thu, Jun 07, 2007 at 01:48:43PM -0400, Joe Lester wrote:
> - The server log shows frequent "archived transaction log file"
> entries. Usually once every 10 minutes or so, but sometimes 2 or 3
> per minute.
Sounds like you've got a lot of writes going. You might want more power in
your I/O?
On Thu, Jun 07, 2007 at 01:48:43PM -0400, Joe Lester wrote:
> of a table). Running the same query 4 times in a row would yield
> dramatically different results... 1.001 seconds, 5 seconds, 22
> seconds, 0.01 seconds, to complete.
> - When queries are especially slow, the server shows a big spi
About six months ago, our normally fast postgres server started
having performance issues. Queries that should have been instant were
taking up to 20 seconds to complete (like selects on the primary key
of a table). Running the same query 4 times in a row would yield
dramatically different
