Re: Using Postgres to store high volume streams of sensor readings

From: Scara Maccai <m_lists(at)yahoo(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Using Postgres to store high volume streams of sensor readings
Date: 2008-11-23 00:54:58
Message-ID: 260691.6571.qm@web28105.mail.ukl.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-11-23 01:09:45 Re: Using Postgres to store high volume streams of sensor readings
Previous Message Tom Lane 2008-11-22 23:20:45 Re: delete commands fails silently to delete primary key