Re: Append only tables

Поиск
Список
Период
Сортировка
От Wim Bertels
Тема Re: Append only tables
Дата
Msg-id 5e922a6609a14085f0851131543d177f74ad867f.camel@ucll.be
обсуждение исходный текст
Ответ на Append only tables  (Kurt Roeckx <kurt@roeckx.be>)
Список pgsql-admin
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




В списке pgsql-admin по дате отправления:

Предыдущее
От: Kurt Roeckx
Дата:
Сообщение: Re: Append only tables
Следующее
От: Keith
Дата:
Сообщение: Re: Append only tables