[postgis-devel] CLUSTER in 8.3

[Obe, Regina]

Actually which version of PostgreSQL 8.3 are you running.  I don't have
the latest install here runing 8.3.1 on windows, but I did upgrade one
of my other boxes to (EL4 to 8.3.5).  Haven't verified that one doesn't
have a cluster issue.

-----Original Message-----
From: postgis-devel-bounces at postgis.refractions.net
[mailto:postgis-devel-bounces at postgis.refractions.net] On Behalf Of Obe,
Regina
Sent: Wednesday, December 03, 2008 9:23 AM
To: PostGIS Development Discussion
Subject: RE: [postgis-devel] CLUSTER in 8.3

Paul,

I hope its just you.  I don't recall running into any problems using
clustered indexes in 8.3 but then all my databases were restored from an
8.2 install but all the clusters look fine as far as I can tell.

I use the below syntax which I thought is the new syntax

ALTER TABLE sometable CLUSTER ON idx_sometable_geom_gist;
CLUSTER sometable;

I just dropped one of my indexes on a table in 8.3 and readded using
above and seems fine as far as I can tell.

When you say all row count - you mean of the table?

Hope that helps,
Regina



-----Original Message-----
From: postgis-devel-bounces at postgis.refractions.net
[mailto:postgis-devel-bounces at postgis.refractions.net] On Behalf Of Paul
Ramsey
Sent: Wednesday, December 03, 2008 9:08 AM
To: PostGIS Development Discussion
Subject: [postgis-devel] CLUSTER in 8.3

Is it just me, or has clustering on spatial indexes stopped working in
8.3? First, the syntax of CLUSTER has been changed, from "CLUSTER
[index] ON [table]" to "CLUSTER [table] USING [index]". Second, when I
run the new syntax using a gist index as the target, the index
disappears and all row count drops to zero!

P.
_______________________________________________
postgis-devel mailing list
postgis-devel at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-devel
-----------------------------------------
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.
_______________________________________________
postgis-devel mailing list
postgis-devel at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-devel