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)
Список
Дерево обсуждения
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 по дате отправления