Re: missing toast table for pg_policy
От
Tom Lane
Тема
Re: missing toast table for pg_policy
Дата
Msg-id
29346.1518970729@sss.pgh.pa.us
Ответ на
Re: missing toast table for pg_policy (Joe Conway)
Список
Дерево обсуждения
missing toast table for pg_policy Joe Conway <mail@joeconway.com>
Re: missing toast table for pg_policy Andres Freund <andres@anarazel.de>
Re: missing toast table for pg_policy Joe Conway <mail@joeconway.com>
Re: missing toast table for pg_policy Tom Lane <tgl@sss.pgh.pa.us>
Re: missing toast table for pg_policy Joe Conway <mail@joeconway.com>
Re: missing toast table for pg_policy Tom Lane <tgl@sss.pgh.pa.us>
Re: missing toast table for pg_policy Joe Conway <mail@joeconway.com>
Re: missing toast table for pg_policy Tom Lane <tgl@sss.pgh.pa.us>
Re: missing toast table for pg_policy Andres Freund <andres@anarazel.de>
Re: missing toast table for pg_policy Joe Conway <mail@joeconway.com>
Re: missing toast table for pg_policy Joe Conway <mail@joeconway.com>
Re: missing toast table for pg_policy Michael Paquier <michael@paquier.xyz>
Re: missing toast table for pg_policy John Naylor <jcnaylor@gmail.com>
Re: missing toast table for pg_policy John Naylor <jcnaylor@gmail.com>
Re: missing toast table for pg_policy Joe Conway <mail@joeconway.com>
Re: missing toast table for pg_policy Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: missing toast table for pg_policy Michael Paquier <michael@paquier.xyz>
Re: missing toast table for pg_policy Joe Conway <mail@joeconway.com>
Re: missing toast table for pg_policy Michael Paquier <michael@paquier.xyz>
Re: missing toast table for pg_policy Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: missing toast table for pg_policy John Naylor <jcnaylor@gmail.com>
Re: missing toast table for pg_policy Michael Paquier <michael@paquier.xyz>
Re: missing toast table for pg_policy Michael Paquier <michael@paquier.xyz>
Re: missing toast table for pg_policy John Naylor <jcnaylor@gmail.com>
Re: missing toast table for pg_policy Michael Paquier <michael@paquier.xyz>
Re: missing toast table for pg_policy Michael Paquier <michael@paquier.xyz>
Re: missing toast table for pg_policy Michael Paquier <michael@paquier.xyz>
Re: missing toast table for pg_policy Andres Freund <andres@anarazel.de>
Re: missing toast table for pg_policy Tom Lane <tgl@sss.pgh.pa.us>
Re: missing toast table for pg_policy Michael Paquier <michael@paquier.xyz>
Re: missing toast table for pg_policy Andres Freund <andres@anarazel.de>
Re: missing toast table for pg_policy Michael Paquier <michael@paquier.xyz>
Re: missing toast table for pg_policy Andres Freund <andres@anarazel.de>
Re: missing toast table for pg_policy John Naylor <jcnaylor@gmail.com>
Re: missing toast table for pg_policy Robert Haas <robertmhaas@gmail.com>
Re: missing toast table for pg_policy Andres Freund <andres@anarazel.de>
Re: missing toast table for pg_policy Michael Paquier <michael@paquier.xyz>
Re: missing toast table for pg_policy Andres Freund <andres@anarazel.de>
Re: missing toast table for pg_policy Michael Paquier <michael@paquier.xyz>
Re: missing toast table for pg_policy Tom Lane <tgl@sss.pgh.pa.us>
Joe Conway writes: > Is there really a compelling reason to not just create toast tables for > all system catalogs as in the attached? What happens when you VACUUM FULL pg_class? (The associated toast table would have to be nonempty for the test to prove much.) I'm fairly suspicious of toasting anything that the toast mechanism itself depends on, actually, and that would include at least pg_attribute and pg_index as well as pg_class. Maybe we could get away with it because there would never be any actual recursion only potential recursion ... but it seems scary. On the whole, I'm dubious that the risk/reward ratio is attractive here. regards, tom lane
В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата: