Re: many tables in db - Mailing list pgsql-general

From Kenneth Been
Subject Re: many tables in db
Date
Msg-id 3B5CA475.2050404@telocity.com
Whole thread Raw
In response to many tables in db  (Kenneth Been <kennethb@telocity.com>)
List pgsql-general
I ran some experiments, and with the queries that I was
testing with, the clustered rtree was about 30% faster than
the unclustered one.

> This isn't really relevant to your main point, but: since an rtree
> doesn't have an associated sort order, it's not clear to me that this
> operation makes any sense.  Have you determined that you'll actually get
> any performance improvement as a result of the clustering?  I suspect
> you may find that you're just rearranging the table into a different
> random order.



pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Does dropping a column from a table mess up foreign keys?
Next
From: "Ian Harding"
Date:
Subject: Re: Re: PG rules!