agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Giles Nelson <Giles.Nelson@cl.cam.ac.uk>
To: postgres@postgres.Berkeley.EDU
Subject: vacuum compaction
Date: Wed, 07 Dec 1994 18:47:55 +0000
Message-ID: <"swan.cl.cam.:267290:941207184809"@cl.cam.ac.uk> (raw)

Dear all.

The footnote on page 66 of the POSTGRES manual supplied with V4.2 states
that the vacuum command does not perform any compaction or clustering of data.
The UNIX files therefore never shrink.

POSTGRES does support time travel of course, but this facility can be removed
with the use of "archive=none" specified when creating a class. Tuples in such
a class are accessible after deletion through time travel functions until both
the class is `purge'd and the the database `vacuum'ed. They are then
permanently deleted.

However from the above statement and the size of my database files such tuples
are not actually removed.

This is a problem for me, as I have a rapid update rate. Most queries are in
fact `replaces'.

I could rebuild the database over-night every night to compress it. However
this seems rather nasty.

So, I'm wondering if anyone has managed to get round this problem and actually
been able to permanently remove tuples!

Yours hopefully,

Giles Nelson.

==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================
              URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: postgres@postgres.berkeley.edu
  Cc: Giles.Nelson@cl.cam.ac.uk
  Subject: Re: vacuum compaction
  In-Reply-To: <"swan.cl.cam.:267290:941207184809"@cl.cam.ac.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox