auto_explain makes CREATE EXTENSION unusable
От | Sandro Santilli |
---|---|
Тема | auto_explain makes CREATE EXTENSION unusable |
Дата | |
Msg-id | 20141118113834.GB8195@localhost обсуждение исходный текст |
Список | pgsql-bugs |
Running 'CREATE EXTENSION postgis' on my machine after enabling auto_explain results in the process writing gigabytes of logs keeping the CPU busy for tens of minutes. RhodiumToad on IRC explained to me: < RhodiumToad> the extension script code doesn't split the script into statements itself, it passes the whole thing to the raw parser and gets back a list of statements As a result, each INSERT statement found in the PostGIS extension script results in the whole extension script (including copyright notices!) being dumped in the logs ("Query Text:"). It is also impossible to know which actual statement the plan refers to as always the same full script is dumped. PostGIS has ~4k INSERT statements in its extension script. While the CREATE EXTENSION statement would take under one second to complete with auto_explain disabled, here's the state of my machine at this very moment, with auto_explain enabled: PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 8905 strk 20 0 4637680 186348 62448 R 99.5 1.1 14:41.26 postgres: strk dbtopo [local] CREATE EXTENSION -rw------- 1 strk strk 10228477364 Nov 18 12:37 /tmp/pg93.log It's been running for almost 15 minutes now, and filling up the logfile. Could this be considered a bug in auto_explain ? --strk; () Free GIS & Flash consultant/developer /\ http://strk.keybit.net/services.html
В списке pgsql-bugs по дате отправления: