PROC_IN_ANALYZE stillborn 13 years ago
От | Alvaro Herrera |
---|---|
Тема | PROC_IN_ANALYZE stillborn 13 years ago |
Дата | |
Msg-id | 20200805235549.GA8118@alvherre.pgsql обсуждение исходный текст |
Ответ на | Re: [DOC] Document concurrent index builds waiting on each other (Alvaro Herrera <alvherre@2ndquadrant.com>) |
Ответы |
Re: PROC_IN_ANALYZE stillborn 13 years ago
|
Список | pgsql-hackers |
Back in the 8.3 cycle (2007) when the autovacuum launcher/worker split was done, we annoyed people because it blocked DDL. That led to an effort to cancel autovac automatically when that was detected, by Simon Riggs. https://postgr.es/m/1191526327.4223.204.camel@ebony.site https://postgr.es/m/1192129897.4233.433.camel@ebony.site I was fixated on only cancelling when it was ANALYZE, to avoid losing any VACUUM work. https://postgr.es/m/20071025164150.GF23566@alvh.no-ip.org That turned into some flags for PGPROC to detect whether a process was ANALYZE, and cancel only those. https://postgr.es/m/20071024151328.GG6559@alvh.no-ip.org Commit: https://postgr.es/m/20071024205536.CB425754229@cvs.postgresql.org https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=745c1b2c2ab However, I was outvoted, so we do not limit cancellation to analyze. Patch and discussion: https://postgr.es/m/20071025164150.GF23566@alvh.no-ip.org Commit: https://postgr.es/m/20071026204510.AA02E754229@cvs.postgresql.org https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=acac68b2bca ... which means the flag I had added two days earlier has never been used for anything. We've carried the flag forward to this day for almost 13 years, dutifully turning it on and off ... but never checking it anywhere. I propose to remove it, as in the attached patch. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Вложения
В списке pgsql-hackers по дате отправления: