"Mr. Dan" <bitsandbytes88@xxxxxxxxxxx> writes: > ... What happens is that we have a 'hot' table (one with many many > transactions) that gets inserted and deleted often. About once a month now > when we do a select from that table the results of the select do not match > the where clause, ex. > select * from recent_projects > where user_id = 139 > sometimes produces these results: > user_id project_id > 139 3 > 139 1 > 139 17 > 754 11 Hmmm .... that looks sorta familiar. What is the query plan that's used for this SELECT? regards, tom lane
