Re: [GENERAL] Vacuuming tables with BRIN index and CLUSTER ON index

2017-03-29 Thread Cherio
On Wed, Mar 29, 2017 at 4:58 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wed, Mar 29, 2017 at 1:34 PM, Cherio wrote: > >> I have an insert/select only table (no update/delete expected) and a BRIN >> index on the timestamp column as follows >

[GENERAL] Vacuuming tables with BRIN index and CLUSTER ON index

2017-03-29 Thread Cherio
I have an insert/select only table (no update/delete expected) and a BRIN index on the timestamp column as follows CREATE TABLE log_table ( id BIGSERIAL NOT NULL, data TEXT, created_at TIMESTAMP WITHOUT TIME ZONE DEFAULT now() CONSTRAINT log_table__pk PRIMARY KEY(id) ); CREATE INDEX log_t