pgsql: Fix CREATE INDEX CONCURRENTLY so that it won't use synchronized

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix CREATE INDEX CONCURRENTLY so that it won't use synchronized
Date: 2008-01-14 01:39:09
Message-ID: 20080114013909.A79E9754108@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Fix CREATE INDEX CONCURRENTLY so that it won't use synchronized scan for
its second pass over the table. It has to start at block zero, else the
"merge join" logic for detecting which TIDs are already in the index
doesn't work. Hence, extend heapam.c's API so that callers can enable or
disable syncscan. (I put in an option to disable buffer access strategy,
too, just in case somebody needs it.) Per report from Hannes Dorbath.

Modified Files:
--------------
pgsql/src/backend/access/heap:
heapam.c (r1.247 -> r1.248)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/heap/heapam.c?r1=1.247&r2=1.248)
pgsql/src/backend/catalog:
index.c (r1.290 -> r1.291)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/index.c?r1=1.290&r2=1.291)
pgsql/src/include/access:
heapam.h (r1.129 -> r1.130)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/access/heapam.h?r1=1.129&r2=1.130)
relscan.h (r1.59 -> r1.60)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/access/relscan.h?r1=1.59&r2=1.60)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2008-01-14 02:49:47 pgsql: Use an indexscan not a heapscan to search pg_index in
Previous Message Tom Lane 2008-01-13 21:17:46 pgsql: Fix a regression test that fails if default_text_search_config