Re: Vaccum - Mailing list pgsql-admin

HI,

This is not necessary true, but you might feel understandable.

To delete records, just seems as the records are marked as voided. Space is not
collected. To run vaccum might do this kind space garbage collection.

To run vacummdb really save the space, but it works at only some extent. e.g.
index still goes quickly, it goes bigger and bigger, one day it eats all your
space you have, behaves as gets a virus. In this case, my solution is to use
pg_dump the original one, create new one and restory, this reaaly save your
space, but you cannot do this as frequently as you do "vacuum". It costs much
more CPU time to do it if your database is huge.

Bangh

"Leong, Fushan" wrote:

> You said "when you delete the records, the space does not get compressed".
> Can you explain
> more for me.  The reason I want to run vacuumdb is to free up some space so
> the database will
> not grow forever..........
>
> -----Original Message-----
> From: bangh [mailto:banghe@baileylink.net]
> Sent: Thursday, November 29, 2001 10:01 AM
> To: Leong, Fushan
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Vaccum
>
> Hello,
>
> You can use vacuum at different levels.
>
> As a command you can use vacuumdb database_name.
>
> In psql, you can use
> psql> vacuum table_name;
>
> I don't think it is going to delete records. To delete records you need to
> issue SQL command:
> like: delete from table_name where condi.
>
> It must delete the cells. when you delete the reocrds, the space does not
> get compressed.
>
> You can check the size changes of a table or database before and after you
> issue "vacuum" command.
>
> You don't need to shut down postmoaster.
>
> It would be nice if you do such jobs at midnight, because such a job does
> keep your CPU busy.
>
> Bangh
>
> "Leong, Fushan" wrote:
>
> > Hi :
> >
> > Want to get your opinion.
> >
> > I am thinking to schedule to run Vaccum everynight.
> >
> > 1) As I understand, Vaccum is the command to delete old data, right?
> > 1) Do I have to stop the postmaster before run the Vaccum command?
> > 2) Should I run it everynight?  How often should I run it?
> >
> > thanks
> > Fushan
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org