Re: INSERT ... ON CONFLICT UPDATE/IGNORE 4.0
От | Tom Lane |
---|---|
Тема | Re: INSERT ... ON CONFLICT UPDATE/IGNORE 4.0 |
Дата | |
Msg-id | 18911.1431112384@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: INSERT ... ON CONFLICT UPDATE/IGNORE 4.0 (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: INSERT ... ON CONFLICT UPDATE/IGNORE 4.0
|
Список | pgsql-hackers |
I wrote: > Peter Geoghegan <pg@heroku.com> writes: >> On Fri, May 8, 2015 at 11:59 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote: >>> Ooops. But shouldn't that have failed 100% of the time in a CCA build? >>> Or is the candidates list fairly noncritical? >> The candidates list is absolutely critical. > Oh, I was confusing CCA with RELCACHE_FORCE_RELEASE, which does something > a bit different. Actually, looking closer, the quoted code is simply not broken without RELCACHE_FORCE_RELEASE: without that, neither heap_close nor index_close will do anything that could cause a cache flush. So while it's certainly good pratice to move that lappend_oid call up, it does not explain the observed symptoms. We still need some more investigation here. regards, tom lane
В списке pgsql-hackers по дате отправления: