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