Re: Cluster and Vacuum Full

2020-10-05 Thread Guillaume Lelarge
Le lun. 5 oct. 2020 à 12:22, PegoraroF10 a écrit : > 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 l

Cluster and Vacuum Full

2020-10-05 Thread PegoraroF10
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 o