From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
---|---|
To: | Postgresql General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: 7.4? |
Date: | 2003-02-25 13:18:27 |
Message-ID: | 20030225081827.C16284@mail.libertyrms.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, Feb 24, 2003 at 03:53:14PM -0500, Ericson Smith wrote:
>
> Will we be able to run the new vacuum system without locking the tables?
I believe the new vacuum stuff is just to help on btree indexes. The
current vacuum doesn't lock the tables, either.
> Currently our database is at about 15gigs. Over the period of a month,
> it grows to about 25gigs (10Gb wasted space). Every month we have a
> cleanup routine which involves copying the most actively updated tables
> to text, and importing the data again. We vacuum every night and analyze
> 4 times per day, but we're loath to do a VACUUM FULL because of the
> table locking issues (locking some of the tables would break the
It sounds like either your free space map is not set correctly, or
you have ever-growing indexes. Reindexing would be enough for this
problem. There are still some 24/7-operation problems with having to
reindex.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2003-02-25 13:22:09 | Re: 7.4? |
Previous Message | Peter Choe | 2003-02-25 13:12:50 | [urgent]need help transferring database to another server |