Re: Inserting heap tuples in bulk in COPY

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Inserting heap tuples in bulk in COPY
Date: 2011-08-12 21:10:11
Message-ID: 4E4596B3.5030501@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 08/12/2011 04:57 PM, Robert Haas wrote:
> I thought about trying to do this at one point in the past, but I
> couldn't figure out exactly how to make it work. I think the approach
> you've taken here is good.
>
> Aside from the point already raised about needing to worry only about
> BEFORE ROW triggers, I don't see any showstoppers.

Yeah, this looks very promising indeed. Well done. In fact, I'm asking
myself how hard it will be to backport for one particular customer of
ours, for whom the WAL load is a major hotspot.

cheers

andrew

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Dimitri Fontaine 2011-08-12 21:10:27 Re: Enforcing that all WAL has been replayed after restoring from backup
Previous Message Robert Haas 2011-08-12 20:57:36 Re: Inserting heap tuples in bulk in COPY