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@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance