Re: Append only tables
| От | Rui DeSousa |
|---|---|
| Тема | Re: Append only tables |
| Дата | |
| Msg-id | 7CBBAB2A-A8C4-47D6-9912-7B3AD6554EAF@crazybean.net обсуждение исходный текст |
| Ответ на | Append only tables (Kurt Roeckx <kurt@roeckx.be>) |
| Ответы |
Re: Append only tables
|
| Список | pgsql-admin |
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 по дате отправления: