mila boldareva <pierro(at)dds(dot)nl> writes:> But the indices are not used, even when I added a separate index on> field1 !
Have you run ANALYZE (or VACUUM ANALYZE) on that table?
regards, tom lane