Postgres Pro
Downloads
Home   >   mailing lists

Skip WAL in ALTER TABLE - Mailing list pgsql-hackers

From Itagaki Takahiro
Subject Skip WAL in ALTER TABLE
Date
Msg-id 20091013113410.A6F8.52131E4D@oss.ntt.co.jp
Whole thread Raw
Responses Re: Skip WAL in ALTER TABLE  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Tree view 
We can skip writing WAL during COPY and CLUSTER if archive_mode is off,
but we don't use the skipping during tables rewrites in ALTER TABLE.
Also we don't use BulkInsertState there.

Is it possible to use WAL-skipping and BulkInsertState in ATRewriteTable() ?
If ok, I'll submit a patch for the next commitfest.

Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: CTE bug?
Next
From: Josh Berkus
Date:
Subject: transaction_isolation vs. default_transaction_isolation