> run vacuum analyze <table>; before running that query, is it still off after > that ? > I forgot to mention that ANALYZE, VACUUM ANALYZE even w/ FULL and REINDEX doesn't help. -- Regards, Sergey Konoplev -- PostgreSQL articles in english & russian http://gray-hemp.blogspot.com/search/label/postgresql/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general