Question about the cluster command - Mailing list pgsql-general

From Anton Andreev
Subject Question about the cluster command
Date
Msg-id 47D99EE3.3020509@fmi.uni-sofia.bg
Whole thread Raw
List 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 by date:

Previous
From: Colin Wetherbee
Date:
Subject: Re: Is there a way to elegantly do a : CREATE TEMP TABLE X AS SELECT .... ON COMMIT DROP
Next
From: Tom Lane
Date:
Subject: Re: Is there a way to elegantly do a : CREATE TEMP TABLE X AS SELECT .... ON COMMIT DROP