<!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>I just tried the below from pgAdmin III on a<BR>
"POSTGIS="1.3.4" GEOS="3.0.3-CAPI-1.4.2" PROJ="Rel. 4.5.0, 22 Oct 2006" USE_STATS PostgreSQL 8.3.5 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20071124 (Red Hat 4.1.2-42)"<BR>
<BR>
create temp table tmp as select st_makepoint(random(), random()) as<BR>
the_geom from generate_series(1, 10000);<BR>
create index tmp_geom_idx on tmp using gist (the_geom);<BR>
analyze tmp;<BR>
select count(*) from tmp;<BR>
<BR>
Correctly returns 10000<BR>
<BR>
But as I mentioned I was able to get it to fail once on this box with Paul's or at least I thought I did, but can't replicate it.<BR>
<BR>
<BR>
-----Original Message-----<BR>
From: postgis-devel-bounces@postgis.refractions.net on behalf of Obe, Regina<BR>
Sent: Fri 12/5/2008 7:03 AM<BR>
To: PostGIS Development Discussion<BR>
Subject: RE: [postgis-devel] CLUSTER in 8.3<BR>
<BR>
> Yuck. If you can definitely confirm that this works on 8.3.3 but not<BR>
> 8.3.5 then it's probably work a post on -hackers :(<BR>
<BR>
<BR>
> ATB,<BR>
<BR>
> Mark.<BR>
<BR>
I ran Kevin's test on 8.3.1 on windows and it ran fine.<BR>
<BR>
create temp table tmp as select st_makepoint(random(), random()) as<BR>
the_geom from generate_series(1, 10000);<BR>
create index tmp_geom_idx on tmp using gist (the_geom);<BR>
analyze tmp;<BR>
select count(*) from tmp;<BR>
<BR>
count = 10000<BR>
<BR>
<BR>
But note I ran Paul's test on 8.3.5 install and got mixed results. I<BR>
could make it happen only<BR>
once and couldn't get it to happen again. I haven't tested the above on<BR>
the 8.3.5 install<BR>
to see if it consistently breaks. So needless to say it seems more than<BR>
8.3.5 may be needed to trigger this condition.<BR>
<BR>
thanks,<BR>
REgina<BR>
-----------------------------------------<BR>
The substance of this message, including any attachments, may be<BR>
confidential, legally privileged and/or exempt from disclosure<BR>
pursuant to Massachusetts law. It is intended<BR>
solely for the addressee. If you received this in error, please<BR>
contact the sender and delete the material from any computer.<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>