Merlin Moncure <[EMAIL PROTECTED]> writes: > On 11/14/05, Tom Lane <[EMAIL PROTECTED]> wrote: >> Do the "duplicate" rows appear to be independent insertions, or >> successive states of the same logical row?
> esp=# select xmin, xmax, lastmod from parts_order_line_file where > prl_combined_key = > esp-# ' 00136860' and prl_seq_no in (20, 23); > xmin | xmax | lastmod > -----------+------+------------------------- > 584527952 | 0 | 2005-09-15 11:17:17.062 > 584527961 | 0 | 2005-09-15 11:17:17.187 > (2 rows) I think you need to try this with enable_indexscan = 0; it should be showing us 4 rows according to your prior result, and it's only showing 2, which suggests that the indexscan is short-circuiting because it "knows" there can only be 1 result row. Also, since you're probing for more than one primary key value, please include the pkey columns in the query so we can tell what's what... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly