<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7653.38">
<TITLE>RE: [postgis-devel] CLUSTER in 8.3</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>As I recall when it failed it didn't just clobber the index, it clobbered all the records when I went to open the table. Very scary<BR>
<BR>
<BR>
-----Original Message-----<BR>
From: postgis-devel-bounces@postgis.refractions.net on behalf of Mark Cave-Ayland<BR>
Sent: Fri 12/5/2008 12:34 PM<BR>
To: PostGIS Development Discussion<BR>
Subject: Re: [postgis-devel] CLUSTER in 8.3<BR>
<BR>
Chris Hodgson wrote:<BR>
> It might be worth trying it on a non-Postgis index... if you can<BR>
> replicate it using a the GiST B-tree implementation on a table full of<BR>
> integers then I expect you could immediately get the attention of the<BR>
> Postgres devs, or at least Oleg and/or Teodor.<BR>
><BR>
> If you can't replicate it that way, it still doesn't rule it out as a<BR>
> Postgresql core or GiST problem... but it certainly suggests that<BR>
> Postgis does something differently that isn't helping.<BR>
><BR>
> Chris<BR>
<BR>
I think the GiST part is a red herring - there is no way that a "SELECT<BR>
COUNT(*) FROM foo" can use an index in PostgreSQL. My suspicion is that<BR>
it's related to the use of ANALYZE/VACUUM/CLUSTER.<BR>
<BR>
<BR>
ATB,<BR>
<BR>
Mark.<BR>
<BR>
--<BR>
Mark Cave-Ayland<BR>
Sirius Corporation - The Open Source Experts<BR>
<A HREF="http://www.siriusit.co.uk">http://www.siriusit.co.uk</A><BR>
T: +44 870 608 0063<BR>
_______________________________________________<BR>
postgis-devel mailing list<BR>
postgis-devel@postgis.refractions.net<BR>
<A HREF="http://postgis.refractions.net/mailman/listinfo/postgis-devel">http://postgis.refractions.net/mailman/listinfo/postgis-devel</A><BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.
</STRONG></P></BODY></HTML>
<P><hr size=1></P>
<P><STRONG><font size="2" color="339900"> Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper. </p> <p> </font></STRONG></P>