| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Re: Disable WAL backup pages when fsync is off |
| Date: | 2005-07-04 01:53:00 |
| Message-ID: | 200507040153.j641r0k21204@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > The following patch disables WAL backup pages when fsync is off.
>
> This is a good idea why?
There is no need to write backup pages if fsync is off. Our TODO has:
* Turn off after-change writes if fsync is disabled
If fsync is off, there is no purpose in writing full pages to WAL
Basically, with fsync off, you are saying you don't care about crash
recovery, so why write those pages?
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2005-07-04 01:57:01 | Re: Disable WAL backup pages when fsync is off |
| Previous Message | Euler Taveira de Oliveira | 2005-07-03 23:35:48 | reindexdb into scripts |