Kevin Buckham <kbuckham@xxxxxxxxxxxxxxx> wrote: > Our primary location table is clustered by "reporttime" (bigint). > Many of the queries we need to perform are of the nature : "get me > all positions from a given device for yesterday". Similar queries > are "get me the most recent 10 positions from a given device". Have you looked at table partitioning? You would then only need to cluster the most recent partition or two. I *seems* like a good fit for your application. http://www.postgresql.org/docs/8.4/interactive/ddl-partitioning.html -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
