Ideas about moving live rows to the top of the table

Поиск
Список
Период
Сортировка
От Антон Пацев
Тема Ideas about moving live rows to the top of the table
Дата
Msg-id CAOx4deopaMY3FGYXfWZhpVQPy18hGD7gpbpDOOR==XMPrJr5gA@mail.gmail.com
обсуждение исходный текст
Список pgsql-hackers
I read about the utility – https://github.com/dataegret/pgcompacttable . It is more careful about resources, because it works on slightly different principles. The main point of pgcompacttable is that it moves all live rows to the beginning of the table with updates in the table. And then it starts a vacuum on this table, because we know that we have live rows at the beginning and dead rows at the end. And the vacuum itself cuts off this tail, i.e. it does not require much additional disk space. Let the auto-vacuum or some other process do this.

--
С уважением, Антон Пацев.
Best regards, Anton Patsev.

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

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: Add explanations which are influenced by track_io_timing
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Inefficiency in SLRU stats collection