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