Because I know everyone loves the spicy zing of anecdata:
Something I've seen more and more since our move to 2.12 is pileups of unapi.bre and biblio.record_copy_count queries. So many and so slow that they've been added to the list of queries that we cancel after 90 seconds. They can run for minutes and minutes if unchecked, and there was one day where postgres was literally crashed due to their piling up. I didn't bug it at the time because I assumed it was a local config bottleneck, but maybe that's not the case? It doesn't seem to be related to metarecords but if the problem is potentially record detail pages they may have some nebulous relation at least.
Because I know everyone loves the spicy zing of anecdata:
Something I've seen more and more since our move to 2.12 is pileups of unapi.bre and biblio. record_ copy_count queries. So many and so slow that they've been added to the list of queries that we cancel after 90 seconds. They can run for minutes and minutes if unchecked, and there was one day where postgres was literally crashed due to their piling up. I didn't bug it at the time because I assumed it was a local config bottleneck, but maybe that's not the case? It doesn't seem to be related to metarecords but if the problem is potentially record detail pages they may have some nebulous relation at least.