vacuum job taking very long time to complete

From: Feite Brekeveld <feite(dot)brekeveld(at)osiris-it(dot)nl>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: vacuum job taking very long time to complete
Date: 2001-06-27 14:10:05
Message-ID: 3B39E93D.8046FD1D@osiris-it.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I've started a vacuumdb on a database having 2 large tables of approx.
3,800,000 records each. The database size is approx . 2Gbyte

It generates a lot of logfiles, currently the pg_xlog directory has
about 4.6 Gbyte of logfiles and when I started there were I guess 2
logfiles each 16 Megs.

I still have 3.5 G available for logfiles but suppose there is a chance
that I will run out of diskspace before the vacuum is done , can I kill
it safely before that happens ?

Thanks,

--
Feite Brekeveld
feite(dot)brekeveld(at)osiris-it(dot)nl

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-06-27 14:24:18 Re: Bug in createlang?
Previous Message Tom Lane 2001-06-27 14:04:23 Re: Why is NULL not indexable?