Re: avoiding WAL logging in 8.3

On Jul 23, 2007, at 11:30 PM, Simon Riggs wrote:
> On Tue, 2007-07-24 at 13:04 +0900, Tatsuo Ishii wrote:
>
>> I noticed in 8.3 there are chances where we can avoid WAL logging.
>> For
>> example, 8.3's pgbench was modified to use TRUNCATE right before
>> COPY. Is there any documentation which describes that kind of
>> techniques? If there's none, I would volunteer the work to create
>> such
>> a documentation since I think this is valuable information for DBAs
>> who wish to migrate to 8.3.
>
> The Performance Tips section has been modified to describe this. Would
> you like me to add something elsewhere also? Multiple entry points to
> information helps everybody, so I'll happily add more.

I would mention it in the documentation for each affected command
(COPY, TRUNCATE, etc). I suspect a lot of folks end up only using the
SQL reference section.
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)