On March 12, 2017 11:22:22 PM PDT, Victor Yegorov <vyego...@gmail.com> wrote: >2016-02-28 11:53 GMT+02:00 Simon Riggs <si...@2ndquadrant.com>: > >> We have various proposals for fixing this, so on consideration here's >what >> I think we should do... >> >> 1. Ignore my first patch to always set an xid. Andres thought that >this >> may break something else could be true, so is not worth the risk. >> >> 2. Apply Konstantin's patch to fix this situation for the specific >case >> only. >> >> 3. Take Andres' idea and build that in as protection. We currently >check >> that nrels != 0 and throw an ERROR. We should do the same thing if >there is >> an invalidation event, so that we catch errors not just ignore them >and >> issue the commit anyway. This will check that there are no other >cases in >> other code. >> > >I have come across this old thread. > >I think we're hitting this particular issue quite frequently when >rebuilding indexes on master after big-volume data manipulations. > >We have `pgbouncer` in transaction mode for both, master and slave, >therefore it's quite typical to have sessions on slave, that >were using indexes before those we're re-created. Sad, but right now >maintenance is a big performance hit for our applications, >we have to re-connect them to start using indexes again. > >Are there any chances to get fix for this issue released in 10.0 and, >perhaps, backpatched also?
I'm not at my computer right now, but I recall committing something like my approach. Andres -- Sent from my Android device with K-9 Mail. Please excuse my brevity. -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers