Cluster and Vacuum Full

From: PegoraroF10 <marcos(at)f10(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: Cluster and Vacuum Full
Date: 2020-10-04 23:37:21
Message-ID: 1601854641360-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have tables which are Master Detail and usually my program loads all detail
records of a master record. So I configured CLUSTER on all those detail
tables to use an index which is the relation with master table. With that I
can load less records to Shared Buffers because all detaild records are on
sequencial pages, that´s fine.

I know that to have this working I have to periodically run CLUSTER, ok too.

But today instead of CLUSTER I just ran VACUUM FULL. How vacuum full
recreates entirelly that table, like cluster does, I thought it would use
that index too, but didn´t. I didn´t see what sequence of records it did but
was not the one I´ve configured with cluster.

Is that expected or Vacuum should obbey cluster configuration ?

--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Han Parker 2020-10-05 05:14:58 May "PostgreSQL server side GB18030 character set support" reconsidered?
Previous Message David G. Johnston 2020-10-04 23:08:18 Re: Writing WAL files