Re: Skip WAL in ALTER TABLE

From: Itagaki Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
To: pgsql-hackers(at)postgresql(dot)org, Simon Riggs <simon(at)2ndQuadrant(dot)com>
Subject: Re: Skip WAL in ALTER TABLE
Date: 2009-10-15 04:18:31
Message-ID: 20091015131605.A2C3.52131E4D@oss.ntt.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Simon Riggs <simon(at)2ndQuadrant(dot)com> wrote:

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

Patch attached.
This patch skip WAL writes during table rewrites from ALTER TABLE.

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

Attachment Content-Type Size
nowal-on-alter-table_20091015.patch application/octet-stream 2.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2009-10-15 05:04:56 Re: Could regexp_matches be immutable?
Previous Message David Fetter 2009-10-15 04:13:05 Re: Could regexp_matches be immutable?