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
>