Re: xlogdump fixups and WAL log question.

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: xlogdump fixups and WAL log question.
Дата
Msg-id
16860.1161367123@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
xlogdump fixups and WAL log question. Theo Schlossnagle <jesus@omniti.com>
Re: xlogdump fixups and WAL log question. "Simon Riggs" <simon@2ndquadrant.com>
Re: xlogdump fixups and WAL log question. Theo Schlossnagle <jesus@omniti.com>
Re: xlogdump fixups and WAL log question. "Simon Riggs" <simon@2ndquadrant.com>
Re: xlogdump fixups and WAL log question. Martijn van Oosterhout <kleptog@svana.org>
Re: xlogdump fixups and WAL log question. Theo Schlossnagle <jesus@omniti.com>
Re: xlogdump fixups and WAL log question. "Simon Riggs" <simon@2ndquadrant.com>
Re: xlogdump fixups and WAL log question. Theo Schlossnagle <jesus@omniti.com>
Re: xlogdump fixups and WAL log question. "Simon Riggs" <simon@2ndquadrant.com>
Re: xlogdump fixups and WAL log question. Tom Lane <tgl@sss.pgh.pa.us>
Re: xlogdump fixups and WAL log question. "Simon Riggs" <simon@2ndquadrant.com>
Re: xlogdump fixups and WAL log question. Alvaro Herrera <alvherre@commandprompt.com>
Re: xlogdump fixups and WAL log question. Tom Lane <tgl@sss.pgh.pa.us>
Re: xlogdump fixups and WAL log question. "Simon Riggs" <simon@2ndquadrant.com>
Re: xlogdump fixups and WAL log question. Theo Schlossnagle <jesus@omniti.com>
Re: xlogdump fixups and WAL log question. Markus Schaber <schabi@logix-tt.com>
Re: xlogdump fixups and WAL log question. Tom Lane <tgl@sss.pgh.pa.us>
Re: xlogdump fixups and WAL log question. Theo Schlossnagle <jesus@omniti.com>
Theo Schlossnagle  writes:
> Is it possible to create tables in fashion that will not write info  
> to the WAL log -- knowingly and intentionally making them  
> unrecoverable?

Use temp tables?

Also, it's likely that much of the WAL volume is full-page images.
While you can't safely turn those off in 8.1, you can dial down the
frequency of occurrence by increasing checkpoint_segments and
checkpoint_timeout as much as you can stand.  (The tradeoffs are
amount of space occupied by pg_xlog/ and time to recover from a crash.)
		regards, tom lane

В списке pgsql-hackers по дате отправления
От: Martijn van Oosterhout
Дата:
От: Tom Lane
Дата:
Сообщение: Re: [PATCHES] zic with msvc
FAQ