Kevin Buckham <kbuckham(at)applocation(dot)net> 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