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
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 |