Re: Bugs in CREATE/DROP INDEX CONCURRENTLY
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andres Freund <andres@2ndquadrant.com>
Cc: Michael Paquier <michael.paquier@gmail.com>, pgsql-hackers@postgresql.org
Date: 2012-11-29T00:30:01Z
Lists: pgsql-hackers
Andres Freund <andres@2ndquadrant.com> writes: > On 2012-11-29 09:10:22 +0900, Michael Paquier wrote: >> and is going to need a lot of rework as well as more infrastructure >> like a better MVCC-ish SnapshotNow. > Which is a major project in itself. I wonder whether my crazy "follow > updates via t_ctid isn't the actually easier way to get there in the > short term. On the other hand, a more MVCCish catalog access would be > awesome. Yeah, eliminating the race conditions for SnapshotNow scans would be valuable enough to justify a lot of work --- we could get rid of a bunch of kluges once we had that, not to mention that Simon's project of reducing ALTER TABLE lock strength might stand a chance of working. regards, tom lane