On Tue, 2023-01-31 at 09:34 -0300, Marcos Pegoraro wrote: > Simon Riggs <[email protected]> escreveu: > > On Tue, 13 Sept 2022 at 13:29, Marcos Pegoraro <[email protected]> wrote: > > > > > > > > What problem do they cause you? > > > > > > > > > They don't cause any problem, I was just trying to get my database as > > > clean as possible. > > > I have some thousands of these toast tables with 8k bytes, so I was > > > trying to eliminate them > > > But if there is no way, ok > > > > They might be optimized away one day, but for now, they are essential. > > When version 16 comes in it´ll be possible to define [1] field STORAGE on > CREATE TABLE step. > I have some thousands of toast files which are completely useless on my > database, so how to remove them. > > pg_upgrade ? Those unneeded toast files will be dropped automatically ? > If not, if I do "alter table x alter column y set storage main" then toast > file will still exist ? > > [1] > https://www.postgresql.org/message-id/flat/[email protected]
Leave them. They won't bother you, and they won't occupy much space. Yours, Laurenz Albe
