Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance issues with large amounts of time-series data - Mailing list pgsql-performance

From Greg Smith
Subject Re: Performance issues with large amounts of time-series data
Date
Msg-id alpine.GSO.2.01.0908271853580.19917@westnet.com
Whole thread Raw
In response to Performance issues with large amounts of time-series data  (Hrishikesh (हृषीकेश मेहेंदळे) <hashinclude@gmail.com>)
Responses Re: Performance issues with large amounts of time-series data  (Hrishikesh (हृषीकेश मेहेंदळे) <hashinclude@gmail.com>)
List pgsql-performance
Tree view 
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 by date:

Previous
From: Jean-Michel Pouré
Date:
Subject: Re: PostgreSQL does CAST implicitely between int and a domain derived from int
Next
From: bricklen
Date:
Subject: Vacuum duration + hint bits?