"Pavan Deolasee" <[EMAIL PROTECTED]> writes: > How about storing the snapshot which we used during planning in > CachedPlanSource, if at least one index was seen unusable because > its CREATE INDEX transaction was seen as in-progress ?
I'm getting tired of repeating this, but: the planner doesn't use a snapshot. System catalogs run on SnapshotNow. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org