On Dec 29, 2010, at 11:16 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> I really really dislike the notion of a "verification scan": it's
> basically work that is going to be useless if it fails.
I think it has potential in cases like text to xml. In that case it'll either work or fail, with no possibility of requiring a do-over. Scanning the whole table is a whole lot cheaper than rewriting it. But I agree with your assessment of the "optimistic" verification scan case.
In response to
pgsql-hackers by date
|Next:||From: Robert Haas||Date: 2010-12-29 18:49:40|
|Subject: Re: Libpq PGRES_COPY_BOTH - version compatibility|
|Previous:||From: Kevin Grittner||Date: 2010-12-29 18:47:37|
|Subject: Re: SSI memory mitigation & false positive degradation|