Re: xlogdump fixups and WAL log question.

Theo Schlossnagle <jesus@omniti.com> 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