To: "Steven Flatt" <steven.flatt@gmail.com>
Cc: "Tom Lane" <tgl@sss.pgh.pa.us>,
	"Bill Moran" <wmoran@collaborativefusion.com>,
	"Vivek Khera" <vivek@khera.org>,
	"Pgsql performance" <pgsql-performance@postgresql.org>
Subject: Re: When/if to Reindex
In-Reply-To: <357fa7590708231525h2f48ce4dw3e48ecca5ccddf72@mail.gmail.com>
	(Steven Flatt's message of "Thu\, 23 Aug 2007 18\:25\:25 -0400")
User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.1 (gnu/linux)
References: <357fa7590707181008k65ab2f20l55bebb3c14f52770@mail.gmail.com>
	<38118C09-FC0A-4CCB-9461-FC6D29D81EE4@khera.org>
	<357fa7590708081212p7b19cbbbn39dbadae8603edd6@mail.gmail.com>
	<20070808152757.9eb9bbcc.wmoran@collaborativefusion.com>
	<11801.1186624308@sss.pgh.pa.us>
	<357fa7590708090651p71b9bc47n66739f8dbbb4ff57@mail.gmail.com>
	<357fa7590708220955h441cd75ap4c0f0342a1c30a14@mail.gmail.com>
	<873aybw2le.fsf@oxford.xeocode.com>
	<357fa7590708231525h2f48ce4dw3e48ecca5ccddf72@mail.gmail.com>
From: Gregory Stark <stark@enterprisedb.com>
Organization: EnterpriseDB
Date: Fri, 24 Aug 2007 07:49:16 +0100
Message-ID: <87tzqp2zrn.fsf@oxford.xeocode.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

"Steven Flatt" <steven.flatt@gmail.com> writes:

> On 8/22/07, Gregory Stark <stark@enterprisedb.com> wrote:
>
> Interestingly enough, the example you've given does not work for me either.
> The select count(*) from test blocks until the reindex completes.  Are we
> using the same pg version?

I was using CVS head but given Tom's explanation I wouldn't expect to see any
different behaviour here.

I just retried it and it did block. I can't think of anything I could have
done wrong last time to make it appear not to block. If I had missed an error
at some point along the way I would have expected the reindex to complete
quickly or fail or something but it was definitely just blocked. I remember
noting (much) later that it had finished.

Strange.

-- 
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com