what happens when concurrent index create

From: leo xu <leoxu8703(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: what happens when concurrent index create
Date: 2012-04-03 16:20:17
Message-ID: 1333470017542-5615720.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

i read documents,i find it that concurrent index create don't lock write.but
need scan table twice.it explain is following as:
It scans the table once to initially build the index, then makes a second
pass to look for things added after the first pass.

please explain 1. what happens when concurrent index create .tks.
2.how to trace a backend what do somethings internal.for
example oracle 10046 trace.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/what-happens-when-concurrent-index-create-tp5615720p5615720.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Haas 2012-04-03 16:25:20 Re: Switching to Homebrew as recommended Mac install?
Previous Message Christopher Browne 2012-04-03 15:56:26 Re: Switching to Homebrew as recommended Mac install?