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

Re: Vacuum taking forever

From: Phillip Smith <phillip(dot)smith(at)weatherbeeta(dot)com(dot)au>
To: "Davidson, Robert" <robdavid(at)amazon(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Vacuum taking forever
Date: 2007-03-22 02:48:53
Message-ID: 1174531733.5365.29.camel@it-laptop (view raw or flat)
Thread:
Lists: pgsql-admin
What are the specs of your machine? What is the memory settings in your
postgresql.conf file?

Cheers
~p

On Wed, 2007-03-21 at 19:42 -0700, Davidson, Robert wrote:
> df –h reports 806 MB free and 79 GB used. Is this enough free space to
> perform a vacuum? Should I export the table, drop it, and re-import
> it?

In response to

pgsql-admin by date

Next:From: Hubertus Freiherr von FuerstenbergDate: 2007-03-22 10:40:11
Subject: Re: growth of the database
Previous:From: Joshua D. DrakeDate: 2007-03-22 02:47:21
Subject: Re: Vacuum taking forever

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