On Sat, Nov 22, 2008 at 5:54 PM, Scara Maccai <m_lists@xxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
