Tom Lane wrote: > For completeness, could we also see ctid in that query? mail=# set enable_indexscan=off; mail=# SELECT xmin, xmax, cmin, cmax,ctid FROM xxx where id = 24613; xmin | xmax | cmin | cmax | ctid ----------+----------+------+----------+--------- 32902771 | 0 | 20 | 32902872 | (0,7) 32902771 | 0 | 20 | 32902872 | (2,27) 32902771 | 0 | 20 | 32902872 | (58,27) 32902771 | 0 | 20 | 32902872 | (60,28) 32902771 | 0 | 20 | 32902872 | (69,3) 32902771 | 33048159 | 20 | 20 | (72,27) (6 rows)
---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
