2010/2/5 Wojtek <foo@xxxxxxxx>: > 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 (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
