Hans Guijt wrote:
I have a fairly large table that keeps track of data measured by our
system. The data is in the form of BLOBs, and is only queried in order
of timestamp. Because we are measuring from multiple devices, the data
does not necessarily arrive in the database in correct temporal order,
and in fact it is very well possible for corrections to some BLOBs to be
entered after measurement. As a result, there is considerable churn in
the table - but only at the very end, in the last hour or so of data.
Older data is normally left alone.
Alternatively, is there some way to do partial clustering? Since 99% of
my data set will already be properly clustered, except for the last 24
hours or so of data, just clustering that last bit (which is trivial by
comparison) would already help a great deal. However, I'm not sure how
to achieve this.
Why not break it up into a partitioning scheme?
Joshua D. Drake
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
