| From: | Christopher Sawtell <csawtell(at)xtra(dot)co(dot)nz> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Backup and analyse |
| Date: | 2001-03-12 21:04:21 |
| Message-ID: | 01031310042100.07173@berty |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I could not easily find answers to these simple questions.
a) Does VACUUMing ( with ANALYSE ) in effect perform a file consistency
check on the database structure as a side effect?
b) Is it ok to VACUUM while the database is alive and active?
c) Can I backup via pg_dump while the database is alive and active and
have the backup consistent to the state the database was in when the
backup started?
I'm 99.99% sure the answers are yes for all of these but I'd very much
like to have it confirmed by somebody who _really knows_.
--
Sincerely etc.,
NAME Christopher Sawtell
CELL PHONE 021 257 4451
ICQ UIN 45863470
EMAIL csawtell @ xtra . co . nz
CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz
-->> Please refrain from using HTML or WORD attachments in e-mails to me
<<--
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-03-12 21:06:38 | Re: Re: Data types? |
| Previous Message | Tom Lane | 2001-03-12 20:53:59 | Re: Poor Delete performance |