Kurt Roeckx schreef op vr 20-03-2020 om 22:50 [+0100]: > Hi, > > I have a few tables that are append only. Thre are only gets insert > and select queries, never update or delete. Hallo Kurt, i would use cstore in your case (fdw for more efficient storage; it is columnar storage, append only data) https://github.com/citusdata/cstore_fdw > > 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 > > > -- mvg, Wim Bertels -- Lector UC Leuven-Limburg -- He that breaks a thing to find out what it is has left the path of wisdom. -- J.R.R. Tolkien
