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

Поиск
Список
Период
Сортировка
От Scara Maccai
Тема Re: Using Postgres to store high volume streams of sensor readings
Дата
Msg-id 260691.6571.qm@web28105.mail.ukl.yahoo.com
обсуждение исходный текст
Ответ на Re: Using Postgres to store high volume streams of sensor readings  ("Ciprian Dorin Craciun" <ciprian.craciun@gmail.com>)
Ответы Re: Using Postgres to store high volume streams of sensor readings  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список 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
ofrows you are inserting maybe the difference in selects would not be that huge.

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: delete commands fails silently to delete primary key
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Using Postgres to store high volume streams of sensor readings