| From: | "Birchall, Austen" <austen(dot)birchall(at)metoffice(dot)gov(dot)uk> |
|---|---|
| To: | <pgsql-novice(at)postgresql(dot)org> |
| Subject: | More WAL archiving/backup questions |
| Date: | 2011-05-12 13:29:41 |
| Message-ID: | A2E53AF8AE1C284C8F8B648653C0920B1D6A4FA8@EXXMAIL02.desktop.frd.metoffice.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hi once again
Am I right to assume that running a pg_dumo -Fc against a database:
(i) Does not require WAL log archiving be be switched on?
(ii) That running this will have no (or a very small) effect on the
database's performance?
Also in general, are there any performance hits from runing in WAL
Archiving mode and also any when a pg_start_backup is actually running
Thanks
Austen
Austen Birchall Senior Database Administrator
Met Office FitzRoy Road Exeter EX1 3PB United Kingdom
Tel: +44 (0)1392 884481 Fax: +44 (0)1392 885681
E-mail: austen(dot)birchall(at)metoffice(dot)gov(dot)uk Website:
http://www.metoffice.gov.uk
| From | Date | Subject | |
|---|---|---|---|
| Next Message | e-letter | 2011-05-14 10:49:16 | select records by nearest value |
| Previous Message | Simon Riggs | 2011-05-12 09:33:37 | Re: WAL logs - do they operate at a database or cluster level? |