Jan Wieck wrote:
>
> Hi,
>
> I just stumbled over a very hard to reproduce error. Running
> a "VACUUM ANALYZE <table>" concurrently to a database heavy
> under load caused a SELECT ... FOR UPDATE with full primary
> key qualification to return multiple results from that table.
> The table contains only a few rows which receive ton's of
> updates.
>
> System is 7.2B3 under Linux.
>
> Will try to produce a test case, just to let ppl know early.
Can you post an explain plan for the query along with a "\d" of the table?