WAL - Mailing list pgsql-general

From Fernando Ipar
Subject WAL
Date
Msg-id 3B812623.6060704@ediguay.com.uy
Whole thread Raw
Responses Re: WAL  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: WAL  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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.

Any help on this subject will be greatly appreciated!! :).

Thanks in advance and sorry for the long post.
--
Fernando Ipar       -       ipar@ediguay.com.uy
-----------------------------------------------


pgsql-general by date:

Previous
From: Justin Clift
Date:
Subject: Re: Real newbie question.
Next
From: newsreader@mediaone.net
Date:
Subject: Re: insert failed