Re: Append only tables

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