"Sergey Konoplev" <gray.ru@xxxxxxxxx> writes: > db_online=> select obj_status_did, count(1) from person_online > where obj_status_did = 1 group by obj_status_did; > QUERY PLAN > ------------------------------------------------------------------------------------------------------------------------- > GroupAggregate (cost=0.00..36.37 rows=1 width=2) (actual > time=1.169..1.170 rows=1 loops=1) > -> Index Scan using i_person_online_test__geo_point on > person_online_test (cost=0.00..30.07 rows=1258 width=2) (actual > time=0.016..0.928 rows=258 loops=1) > Total runtime: 1.268 ms > (3 rows) Hmm. So the problem seems to be statable as "a full-index scan on a GIST index might fail to return all the rows, if the index has been modified since creation". Teodor, can you think of anything you changed recently in that area? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
