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 [EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
