On Sat, Nov 22, 2008 at 5:54 PM, Scara Maccai <[EMAIL PROTECTED]> wrote: > Since you always need the timestamp in your selects, have you tried indexing > only the timestamp field? > Your selects would be slower, but since client and sensor don't have that > many distinct values compared to the number of rows you are inserting maybe > the difference in selects would not be that huge.
Even better might be partitioning on the timestamp. IF all access is in a certain timestamp range it's usually a big win, especially because he can move to a new table every hour / day / week or whatever and merge the old one into a big "old data" table. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
