| From: | Rick Gigger <rick(at)alpinenetworking(dot)com> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Martijn van Oosterhout <kleptog(at)svana(dot)org>, Greg Stark <gsstark(at)mit(dot)edu>, Rod Taylor <pg(at)rbt(dot)ca>, Qingqing Zhou <zhouqq(at)cs(dot)toronto(dot)edu>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and |
| Date: | 2006-02-07 04:07:41 |
| Message-ID: | D8417238-847B-4591-A730-899206F3B760@alpinenetworking.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
I was thinking the exact same thing. Except the "and just fsync()
dirty pages on commit" part. Wouldn't that actually make the
situation worse? I thought the whole point of WAL was that it was
more efficient to fsync all of the changes in one sequential write in
one file rather than fsyncing all of the separate dirty pages.
On Feb 6, 2006, at 7:24 PM, Christopher Kings-Lynne wrote:
>> * Allow WAL logging to be turned off for a table, but the table
>> might be dropped or truncated during crash recovery [walcontrol]
>>
>> Allow tables to bypass WAL writes and just fsync() dirty pages on
>> commit. This should be implemented using ALTER TABLE, e.g. ALTER
>> TABLE PERSISTENCE [ DROP | TRUNCATE | DEFAULT ]. Tables using
>> non-default logging should not use referential integrity with
>> default-logging tables. A table without dirty buffers during a
>> crash could perhaps avoid the drop/truncate.
>
> This would be such a sweet feature for website session tables...
>
> Chris
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2006-02-07 04:13:59 | Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and |
| Previous Message | Doug McNaught | 2006-02-07 02:27:45 | Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and |