Bug report: Dramatic increase in conflict with recovery afterupgrading 10.2->10.5 - Mailing list pgsql-hackers

From Chris Travers
Subject Bug report: Dramatic increase in conflict with recovery afterupgrading 10.2->10.5
Date
Msg-id CAN-RpxAZeKt6wvEXK-3uR91y_V6BmpYxGxZAZK03piFpX_oJMQ@mail.gmail.com
Whole thread Raw
Responses Re: Bug report: Dramatic increase in conflict with recovery afterupgrading 10.2->10.5  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-hackers
I haven't done significant debugging on this yet but if anyone else has seen this problem and can point me at anything this would be good.  Otherwise I believe we will expect to debug and try to fix this problem soon.

After upgrading to PostgreSQL 10.5 from 10.2, we went from one type of query having about one recovery conflict per month to about three or so every two days.  The queries in question should usually complete very fast and should never hit the 30 sec max standby delay.

At present I believe this to likely be a regression.  But if nobody else knows otherwise, I should know more in a couple days.

--
Best Regards,
Chris Travers
Head of Database

Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com 
Saarbrücker Straße 37a, 10405 Berlin

pgsql-hackers by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: Latest HEAD fails to build
Next
From: Alexander Kuzmenkov
Date:
Subject: Re: Avoid extra Sort nodes between WindowAggs when sorting can bereused