>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:
>> Notice that the two rows seem entirely independent (different
>> xmin). The OP stated that his app generally does single-row
>> inserts (with some exceptions not relevent here); however, we
>> found a nearby row which shares the xmin:
Tom> How is the timestamp column generated? I'm wondering what we
Tom> can deduce from the fact that the timestamps are all different.
Tom> It's evidently not now().
(answering this one since the OP has probably gone for the night)
My understanding is that it is now(), but the OP should be able to
give a definitive answer. (Yes, this does raise some questions about
why it appears to have gone backwards at some points.)
Tom> One thing that seems odd is that the xids are kinda small. Did
Tom> the system just recently have a wraparound event?
The system was recently dump/restored from a different box. The
failing rows are all new inserts since the restore.
--
Andrew (irc:RhodiumToad)