Re: COPY with hints, rebirth - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: COPY with hints, rebirth
Date
Msg-id 4F522F300200002500045EFD@gw.wicourts.gov
Whole thread Raw
In response to COPY with hints, rebirth  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
> Simon Riggs  wrote:
> Kevin Grittner  wrote:
>> Simon Riggs  wrote:
>>
>>> I like Marti's idea. At present, making his idea work could
>>> easily mean checksums sink
>> For my part, improving bulk load performance and TRUNCATE
>> transactional semantics would trump checksums
> It doesn't look like it needs to be either-or.
Great news!
> Please review the safe_truncate.v2.patch and
> copy_autofrozen.v359.patch, copied here to assist testing and
> inspection.
I'll look at it today.
> At present those patches handle only the TRUNCATE/COPY optimisation
> but we could easily add CTAS, CREATE/COPY, CLUSTERVACUUM FULL etc..
CREATE/COPY would be important so that pg_dump | psql -1 would
benefit.
-Kevin


pgsql-hackers by date:

Previous
From: Jeff Janes
Date:
Subject: tuplesort memory usage: grow_memtuples
Next
From: Alvaro Herrera
Date:
Subject: poll: CHECK TRIGGER?