Theo Schlossnagle <jesus(at)omniti(dot)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