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
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 |