Re: Why will vacuum not end?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Shea,Dan [CIS]" <Dan(dot)Shea(at)ec(dot)gc(dot)ca>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Why will vacuum not end?
Date: 2004-04-24 15:35:21
Message-ID: 200404240835.21914.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Dan,

> Josh, how long should a vacuum take on a 87 GB table with a 39 GB index?

Depends:
-- 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?

--
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2004-04-24 15:37:42 Re: Setting Shared Buffers , Effective Cache, Sort Mem
Previous Message Shea,Dan [CIS] 2004-04-24 14:45:40 Re: Why will vacuum not end?