Re: Performance issues with large amounts of time-series data

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: Performance issues with large amounts of time-series data
Дата
Msg-id alpine.GSO.2.01.0908271853580.19917@westnet.com
обсуждение исходный текст
Ответ на Performance issues with large amounts of time-series data  (Hrishikesh (हृषीकेश मेहेंदळे) <hashinclude@gmail.com>)
Ответы Re: Performance issues with large amounts of time-series data
Список pgsql-performance
Дерево обсуждения 
On Wed, 26 Aug 2009, Hrishikesh (??????? ????????) wrote:

> key = {device_id (uint64), identifier (uint32), sub_identifier (uint32), unix_time} (these four taken together are
unique)

You should probably tag these fields as NOT NULL to eliminate needing to
consider that possibility during query planning.  As of V8.3 this isn't as
critical anymore, but it's still good practice.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

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

Предыдущее
От: Jean-Michel Pouré
Дата:
Сообщение: Re: PostgreSQL does CAST implicitely between int and a domain derived from int
Следующее
От: bricklen
Дата:
Сообщение: Vacuum duration + hint bits?