Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
Дата
Msg-id 43E804DF.5020408@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and  (Rick Gigger <rick@alpinenetworking.com>)
Список pgsql-hackers
>     * 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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
Следующее
От: Doug McNaught
Дата:
Сообщение: Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and