> Josh, how long should a vacuum take on a 87 GB table with a 39 GB index?
-- What's your disk support?
-- VACUUM, VACUUM ANALYZE, or VACUUM FULL?
-- What's your vacuum_mem setting?
-- What are checkpoint and wal settings?
> I see alot of activity with transaction logs being recycled (15 to 30 every
> 3 to 20 minutes).
> Is the vacuum causing this?
Probably, yes. How many checkpoint_buffers do you allow?
Aglio Database Solutions
In response to
pgsql-performance by date
|Next:||From: Josh Berkus||Date: 2004-04-24 15:37:42|
|Subject: Re: Setting Shared Buffers , Effective Cache, Sort Mem|
|Previous:||From: Shea,Dan [CIS]||Date: 2004-04-24 14:45:40|
|Subject: Re: Why will vacuum not end?|