Still getting a seq scan after doing vacuum analyze. Any other ideas? 2009/5/27 Grzegorz Jaśkiewicz <gryzman@xxxxxxxxx>: > you have to vacuum analyze after you've created index, afaik. > No, count(*) is still counting rows. > -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance