[postgis-devel] CLUSTER in 8.3

[Paul Ramsey]

You clustered ttt then you counted all_counties...

P

On Thu, Dec 4, 2008 at 8:44 PM, Obe, Regina <robe.dnd at cityofboston.gov> wrote:
> I tried your test on my all_counties table and it worked fine.  But I was
> doing it from pgadmin III.  and I have left out that  clusture thing you
> were doing.  What does that do? :)
>
> create table ttt as select * from all_counties;
> create index ttt_gix on ttt using gist(the_geom);
> cluster ttt using ttt_gix;
> select count(*) from all_counties;
>
> -- gives me 3141 records --
>
> I guess we must have similar county tables since we have the same record
> count.
>
> My projection is in 3395.
>
> running
> "PostgreSQL 8.3.5 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.2
> 20071124 (Red Hat 4.1.2-42)"
> "POSTGIS="1.3.4" GEOS="3.0.3-CAPI-1.4.2" PROJ="Rel. 4.5.0, 22 Oct 2006"
> USE_STATS"
>
> Hope that helps,
> Regina
>
> -----Original Message-----
> From: postgis-devel-bounces at postgis.refractions.net on behalf of Paul Ramsey
> Sent: Thu 12/4/2008 3:37 PM
> To: PostGIS Development Discussion
> Subject: Re: [postgis-devel] CLUSTER in 8.3
>
> Maybe I'm doing something wrong... here's a log of how I exercised this:
>
> pramsey=# create table ttt as select * from counties;
> SELECT
> pramsey=# create index ttt_gix on ttt using gist(the_geom);
> CREATE INDEX
> pramsey=# clusture
> pramsey=# select count(*) from ttt;
>  count
> -------
>   3141
> (1 row)
>
> pramsey=# cluster ttt using ttt_gix;
> CLUSTER
> pramsey=# select count(*) from ttt;
>  count
> -------
>      0
> (1 row)
>
> pramsey=# select version();
>                                                            version
> ------------------------------------------------------------------------------------------------------------------------------
>  PostgreSQL 8.3.5 on i386-apple-darwin9.5.0, compiled by GCC
> i686-apple-darwin9-gcc-4.0.1 (GCC) 4.0.1 (Apple Inc. build 5465)
> (1 row)
>
> pramsey=# select postgis_full_version();
>                                 postgis_full_version
> -------------------------------------------------------------------------------------
>  POSTGIS="1.3.4SVN" GEOS="3.1.0-CAPI-1.5.0" PROJ="Rel. 4.6.0, 21 Dec
> 2007" USE_STATS
> (1 row)
>
> pramsey=#
>
>
> On Wed, Dec 3, 2008 at 8:43 AM, Kevin Neufeld <kneufeld at refractions.net>
> wrote:
>> Is seems fine (for Points anyway) on my 8.3.3 install running on an old
>> FC3
>> box.
>>
>> Did you run out of disk space?  Did the transaction get half way through
>> and
>> was forced to stop?
>>
>> -- Kevin
>>
>> Paul Ramsey wrote:
>>>
>>> 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
>>
>> _______________________________________________
>> postgis-devel mailing list
>> postgis-devel at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-devel
>>
> _______________________________________________
> 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.
>
> ________________________________
>
> Help make the earth a greener place. If at all possible resist printing this
> email and join us in saving paper.
>
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel
>
>