RE: Temporary tables prevent autovacuum, leading to XID wraparound
От | Tsunakawa, Takayuki |
---|---|
Тема | RE: Temporary tables prevent autovacuum, leading to XID wraparound |
Дата | |
Msg-id | 0A3221C70F24FB45833433255569204D1F8AE239@G01JPEXMBYT05 обсуждение исходный текст |
Ответ на | Re: Temporary tables prevent autovacuum, leading to XID wraparound (Robert Haas <robertmhaas@gmail.com>) |
Ответы |
Re: Temporary tables prevent autovacuum, leading to XID wraparound
|
Список | pgsql-hackers |
From: Robert Haas [mailto:robertmhaas@gmail.com] > Temporary tables contain XIDs, so they need to be vacuumed for XID > wraparound. Otherwise, queries against those tables by the session > that created them could yield wrong answers. However, autovacuum > can't perform that vacuuming; it would have to be done by the session. > I think we should consider having backends try to remove their > temporary schema on startup; then, if a temp table in a backend is old > enough that it's due for vacuum for wraparound, have autovacuum kill > the connection. The former is necessary to prevent sessions from > being killed on account of temp tables they "inherited" from a backend > that didn't exit cleanly. The attached patch does the former. The small change in autovacuum.c is mainly for autovac launcher and background workerswhich don't connect to a database. I'll add this to the next CF. I'd like this to be back-patched. I didn't do the latter, because killing the connection seemed a bit overkill. If we're going to do it, then we should alsokill the connection which is preventing vacuum regardless of whether it has temporary tables in its session. Regards Takayuki Tsunakawa
Вложения
В списке pgsql-hackers по дате отправления: