From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Hans Guijt <hg(at)terma(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Less intrusive ways to cluster? |
Date: | 2008-01-08 16:49:08 |
Message-ID: | 4783A984.10602@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2008-01-08 17:25:49 | Re: user login: problems in linux |
Previous Message | Hans Guijt | 2008-01-08 16:44:10 | Less intrusive ways to cluster? |