> 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