WAL

From: Fernando Ipar <ipar(at)ediguay(dot)com(dot)uy>
To: pgsql-general(at)postgresql(dot)org
Subject: WAL
Date: 2001-08-20 15:00:51
Message-ID: 3B812623.6060704@ediguay.com.uy
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)ediguay(dot)com(dot)uy
-----------------------------------------------

Responses

  • Re: WAL at 2001-08-20 20:52:14 from Bruce Momjian
  • Re: WAL at 2001-08-20 21:05:34 from Tom Lane

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2001-08-20 15:17:06 Re: Real newbie question.
Previous Message Raymond Chui 2001-08-20 14:08:36 How to execute a system file in procedure?