| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Cc: | Theo Schlossnagle <jesus(at)omniti(dot)com>, pgsql-hackers(at)postgresql(dot)org, Diogo Biazus <diogob(at)gmail(dot)com> |
| Subject: | Re: xlogdump fixups and WAL log question. |
| Date: | 2006-10-21 10:08:41 |
| Message-ID: | 20061021100841.GA17936@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sat, Oct 21, 2006 at 10:37:51AM +0100, Simon Riggs wrote:
> Turning off WAL is a difficult topic. Without it you have no crash
> recovery, which IMHO everybody says they don't care about until they
> crash, then they realise. It's hard to be selective about writing WAL
> for specific operations also.
It's been discussed before. One idea is to declare tables without
logging. The idea being that during recovery those tables and related
indexes are simply truncated. No foreign keys allowed. Obviously they
will not be saved via PITR either.
Put another way, the table structure is saved in WAL, but the data
isn't.
Have a ncie day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2006-10-21 10:37:02 | Re: adminpack and pg_catalog |
| Previous Message | dakotali kasap | 2006-10-21 09:50:07 | Re: Want to use my own query-plan |