Re: Vaccum

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(at)baileylink(dot)net]
Sent: Thursday, November 29, 2001 10:01 AM
To: Leong, Fushan
Cc: pgsql-admin(at)postgresql(dot)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