Question about the cluster command

Поиск
Список
Период
Сортировка
От Anton Andreev
Тема Question about the cluster command
Дата
Msg-id 47D99EE3.3020509@fmi.uni-sofia.bg
обсуждение исходный текст
Список pgsql-general
Hi,

Can I cluster the tuples in a table like that:

group by company_id order by opendate desc

How do I create an index representing the above logic to use it with the
cluster command. Can I automate the clustering process to best optimize
my database performance and always get the data about a specific company
ordered by date as fast as possible (to generate charts). Does
autovacuum include reclustering?

Cheers,
Anton Andreev


В списке pgsql-general по дате отправления:

Предыдущее
От: Colin Wetherbee
Дата:
Сообщение: Re: Is there a way to elegantly do a : CREATE TEMP TABLE X AS SELECT .... ON COMMIT DROP
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Is there a way to elegantly do a : CREATE TEMP TABLE X AS SELECT .... ON COMMIT DROP