| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Michael Paesold <mpaesold(at)gmx(dot)at> |
| Cc: | PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Re: Disable page writes when fsync off, add GUC |
| Date: | 2005-07-06 14:45:13 |
| Message-ID: | 200507061445.j66EjDf17572@candle.pha.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Michael Paesold wrote:
> Bruce Momjian wrote:
>
> > Bruce Momjian wrote:
> >> This also adds a full_page_writes GUC to turn off page writes to WAL.
> >> Some people might not want full_page_writes.
> >
> > Fsync linkage removed, patch attached and applied.
>
> ...
> + When this option is on, the <productname>PostgreSQL</> server
> + writes full pages to WAL when they first modified after a checkpoint
> + so full recovery is possible.
>
> I believe this should be "when they _are_ first modified after".
>
> Perhaps you should also mention power failure, not only an operating system
> crash as disaster scenario, even if the latter includes the former.
>
Thanks. Done.
--
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
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/plain | 1.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2005-07-06 14:46:56 | Re: timezone changes break windows and cygwin |
| Previous Message | Tom Lane | 2005-07-06 14:35:37 | Re: By Passed Domain Constraints |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Neil Conway | 2005-07-06 15:20:13 | Re: User's exception plpgsql |
| Previous Message | Tom Lane | 2005-07-06 14:22:51 | Re: patch: garbage error strings in libpq |