Re: [HACKERS] avoiding WAL logging in 8.3

2007-07-24 Thread Simon Riggs
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

Re: [HACKERS] avoiding WAL logging in 8.3

2007-07-24 Thread Tatsuo Ishii
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

Re: [HACKERS] avoiding WAL logging in 8.3

2007-07-24 Thread Simon Riggs
On Tue, 2007-07-24 at 18:45 +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

Re: [HACKERS] avoiding WAL logging in 8.3

2007-07-24 Thread Jim Nasby
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

[HACKERS] avoiding WAL logging in 8.3

2007-07-23 Thread Tatsuo Ishii
Hi, 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