Re: WAL

> Hi, this is my first message to the list.
> I've been looking for some documentation regarding WAL
> configuration. Particulary, i want to know if there's
> a way to inhibit WAL for a certain table or for
> certain periods of time (i.e., during batch loads,
> when i don't really care for transaction logging since
> if anything goes wrong i can just restart the whole
> process without affecting the integrity of the table).
>
> I've searched the archives before asking and the only
> thing related to this was found on the hackers list,
> it explained how to limit the size and number of
> the WAL files, but it involved a patch to the
> code. I don't have a problem with patchin the source
> if this is the last resource, but it would be
> great if this could be done with a configuration
> directive (i didn't find anything related to this
> on the admin manual so this is probably impossible)
> or with a SQL command.

7.1.3 is only going to use a few log segments no matter how large your
transaction is.  It still does the writes, though.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026