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

From Kevin Grittner
Subject Re: COPY with hints, rebirth
Date
Msg-id 4F5100430200002500045E86@gw.wicourts.gov
Whole thread Raw
In response to Re: COPY with hints, rebirth  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: COPY with hints, rebirth
List pgsql-hackers
Simon Riggs <simon@2ndQuadrant.com> wrote:
> I like Marti's idea. At present, making his idea work could easily
> mean checksums sink, so not sure whether to attempt to make that
> work in detail.
For my part, improving bulk load performance and TRUNCATE
transactional semantics would trump checksums.  If we have to defer
one or the other to a later release, I would prefer that we bump
checksums.
While I understand the desire for checksums, and understand others
have had situations where they would have helped, so far I have yet
to run into a situation where I feel they would have helped me.  The
hint bit and freeze issues require ongoing attention and have real
performance consequences on a regular basis.  And closing the window
for odd transactional semantics on TRUNCATE versus DELETE of all
rows in a table would be one less thing to worry about, in my world.
-Kevin


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: COPY with hints, rebirth
Next
From: Thom Brown
Date:
Subject: Re: Command Triggers, patch v11