Re: [GENERAL] Strange case of database bloat

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: [GENERAL] Strange case of database bloat
Дата
Msg-id CAMkU=1wLggpgtb4=kve4G6zpMCKiiF=TLBAFd1WyTrL8QhKPtg@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] Strange case of database bloat  (Chris Travers <chris.travers@gmail.com>)
Список pgsql-general
On Tue, Jul 4, 2017 at 10:18 PM, Chris Travers <chris.travers@gmail.com> wrote:

Questions
===========
I assume that it is the fact that rows update frequently which is the problem here? But why doesn't Postgres re-use any of the empty disk pages?

Can you install the contrib extension pg_freespacemap and use "select * from pg_freespace('table_name')" to see if PostgreSQL agrees that the space is re-usable?

Cheers,

Jeff

В списке pgsql-general по дате отправления: