- Mailing list pgsql-general

From roypgsqlgen@xemaps.com
Subject
Date
Msg-id 200110151813.f9FIDrX75840@mail1.hub.org
Whole thread Raw
Responses Re:  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
>There is a faster, non-exclusive-locking VACUUM in the CVS now; this
>should become part of 7.2. You can download the nightly snapsot and build
>it to test it with your application.
>HTH.

OK, so from what I understand if you don't tell it to do a "FULL" vacuum, it will not minimize space by moving tuples
acrssblocks to compact a table.  But does that mean at some point you have to do a "FULL" vacuum? 

Roy.




pgsql-general by date:

Previous
From: xavier.goddeeris@dds.delphiauto.com (Xavier Goddeeris)
Date:
Subject: Why do I get a circular query when I insert tuples with this rule ?
Next
From: Gaurav Priyolkar
Date:
Subject: Re: "Relation x does not exist" error when x does exist