Re: Possible bug in new VACUUM code - Mailing list pgsql-hackers

From mlw
Subject Re: Possible bug in new VACUUM code
Date
Msg-id 3C04D161.A42A2C46@mohawksoft.com
Whole thread Raw
In response to Possible bug in new VACUUM code  (Jan Wieck <janwieck@yahoo.com>)
List pgsql-hackers
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?


pgsql-hackers by date:

Previous
From: "Zeugswetter Andreas SB SD"
Date:
Subject: Re: Call for platform testing
Next
From: "August Zajonc"
Date:
Subject: Sequence docs