Query About vacuum and pg_dump

From: PRAGATI SAVAIKAR <pragati(at)phildigital(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Query About vacuum and pg_dump
Date: 2003-05-08 04:30:36
Message-ID: 3EB9DD6B.A3CCFB03@phil.com.sg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi!!!!!

We have got "PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC
2.96 " running on Linux 7.3.
There are 2 databases , each of size 16 GB.

I have 2 queries regarding vacuum and pg_dump.

VACUUM :

We run "vacuum " for each of the table in the database on daily basis.
But it doesn't seem to reduce the disk space.
We also tried using "vacuum analyze". But no change was observed.

pg_dump:
we use pg_dump command to take the backup of the databases .
I would like to know, how will it affect if I run the pg_dump while the
tables are being used or when the transactions are being processed.

Thanks in advance and Waiting for your speedy reply.

--
Regards,
Pragati

Whatever you do will be insignificant, but it is very important that you do it.
-- Gandhi

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gémes Géza 2003-05-08 12:35:27 Re: Upgrade to RH9.....Help....PostgreSQL newbie
Previous Message Terence Ng 2003-05-08 03:09:45 Multilingual database