2010/2/5 Wojtek <[email protected]>: > Most of my queries will have where conditions on timedate and sys_device_id, > but a lot of them will have additional clause: where usefields is not null. > Some of the queries will be limited on timedate only.
What about a partial index on (timedate) WHERE usefields IS NOT NULL; or maybe on (timedate, sys_device_id) WHERE usefields IS NOT NULL? ...Robert -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
