Theo Schlossnagle <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?


Reply via email to