[postgis-devel] CLUSTER in 8.3
mark.cave-ayland at siriusit.co.uk
Fri Dec 5 09:31:25 PST 2008
Obe, Regina wrote:
> I just tried the below from pgAdmin III on a
> "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)"
> create temp table tmp as select st_makepoint(random(), random()) as
> the_geom from generate_series(1, 10000);
> create index tmp_geom_idx on tmp using gist (the_geom);
> analyze tmp;
> select count(*) from tmp;
> Correctly returns 10000
> 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.
Well, it is an intermittent bug - I have re-run it several times,
restarting PostgreSQL, before I see the failure.
Sirius Corporation - The Open Source Experts
T: +44 870 608 0063
More information about the postgis-devel