Append only tables
От | Kurt Roeckx |
---|---|
Тема | Append only tables |
Дата | |
Msg-id | 20200320215053.GH22330@roeckx.be обсуждение исходный текст |
Ответы |
Re: Append only tables
Re: Append only tables Re: Append only tables |
Список | pgsql-admin |
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. I assume that that the free space map is being used, and that it still finds places where it can insert a row in one of the files. (auto) vacuum is not happening on the table. Is there a way I can turn off this behaviour, and that it really only writes to the last few pages? Kurt
В списке pgsql-admin по дате отправления: