Re: many tables in db

Поиск
Список
Период
Сортировка
От Kenneth Been
Тема Re: many tables in db
Дата
Msg-id 3B5CA475.2050404@telocity.com
обсуждение исходный текст
Ответ на many tables in db  (Kenneth Been <kennethb@telocity.com>)
Список 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 по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Does dropping a column from a table mess up foreign keys?
Следующее
От: "Ian Harding"
Дата:
Сообщение: Re: Re: PG rules!