Re: Append only tables
От
Rui DeSousa
Тема
Re: Append only tables
Дата
Msg-id
7CBBAB2A-A8C4-47D6-9912-7B3AD6554EAF@crazybean.net
Ответ на
Append only tables (Kurt Roeckx)
Список
Дерево обсуждения
Append only tables Kurt Roeckx <kurt@roeckx.be>
Re: Append only tables Wim Bertels <wim.bertels@ucll.be>
Re: Append only tables Laurenz Albe <laurenz.albe@cybertec.at>
Re: Append only tables Kurt Roeckx <kurt@roeckx.be>
Re: Append only tables Rui DeSousa <rui@crazybean.net>
Re: Append only tables Kurt Roeckx <kurt@roeckx.be>
Re: Append only tables Rui DeSousa <rui@crazybean.net>
Re: Append only tables Kurt Roeckx <kurt@roeckx.be>
Re: Append only tables Rui DeSousa <rui@crazybean.net>
Re: Append only tables Kurt Roeckx <kurt@roeckx.be>
Re: Append only tables Rui DeSousa <rui@crazybean.net>
Re: Append only tables Rui DeSousa <rui@crazybean.net>
Re: Append only tables Keith <keith@keithf4.com>
On Mar 20, 2020, at 5:50 PM, Kurt Roeckx <kurt@roeckx.be> wrote:Hi,
I have a few tables that are append only. Thre are only gets insert
and select queries, never update or delete.
What I see is that every file is still being updated. It's
currently about 500 GB big, and every of that almost 500 files has
been touched the past 24 hours.
(auto) vacuum is not happening on the table.
It could be the result of records being frozen during selects statements; select can freeze tuples that meet the criteria for being frozen.
I would recommend vacuuming the table to get the existing records frozen; then I believe you should see fewer updates to the all the base files.
В списке pgsql-admin по дате отправления
