Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Josh BerkusDate: 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?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group