Re: toast useless
| От | Marcos Pegoraro |
|---|---|
| Тема | Re: toast useless |
| Дата | |
| Msg-id | CAB-JLwZe_mfgRMDQP5RVkT-mkrWZX6+FJFM6Ld2_j2HU1jisBw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: toast useless (Simon Riggs <simon.riggs@enterprisedb.com>) |
| Ответы |
Re: toast useless
|
| Список | pgsql-general |
Simon Riggs <simon.riggs@enterprisedb.com> escreveu:
On Tue, 13 Sept 2022 at 13:29, Marcos Pegoraro <marcos@f10.com.br> 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 ?
В списке pgsql-general по дате отправления: