Message-ID: <8aacabc6-5919-5f37-9c9a-2a3cd67adfa3@jakobs.com>
Date: Tue, 7 Feb 2023 17:56:22 +0100
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.6.1
To: pgsql-admin@lists.postgresql.org
References: 
 <CA+dvXXu2krLsS3K_GJkdrCT1hbu+G0rxAjh1KKot5TGrBpn8AA@mail.gmail.com>
From: Holger Jakobs <holger@jakobs.com>
Subject: Re: Vacuum Full not clean the table
In-Reply-To: 
 <CA+dvXXu2krLsS3K_GJkdrCT1hbu+G0rxAjh1KKot5TGrBpn8AA@mail.gmail.com>
Content-Type: multipart/signed; micalg=pgp-sha256;
 protocol="application/pgp-signature";
 boundary="------------1XQa8LkwqzbzW36bhI30RNwp"
Archived-At: 
 <https://www.postgresql.org/message-id/8aacabc6-5919-5f37-9c9a-2a3cd67adfa3%40jakobs.com>
Precedence: bulk

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--------------1XQa8LkwqzbzW36bhI30RNwp
Content-Type: multipart/mixed; boundary="------------UheWNlWnOVqrvd0CzZRX8Kny";
 protected-headers="v1"
From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Message-ID: <8aacabc6-5919-5f37-9c9a-2a3cd67adfa3@jakobs.com>
Subject: Re: Vacuum Full not clean the table
References: <CA+dvXXu2krLsS3K_GJkdrCT1hbu+G0rxAjh1KKot5TGrBpn8AA@mail.gmail.com>
In-Reply-To: <CA+dvXXu2krLsS3K_GJkdrCT1hbu+G0rxAjh1KKot5TGrBpn8AA@mail.gmail.com>

--------------UheWNlWnOVqrvd0CzZRX8Kny
Content-Type: multipart/alternative;
 boundary="------------q25ty16vW6gV5L7Yba6egP2o"

--------------q25ty16vW6gV5L7Yba6egP2o
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: base64

QW0gMDcuMDIuMjMgdW0gMTc6NTEgc2NocmllYiBFcmlrIFNlcnJhbm86DQo+IERlYXIgQWxs
LA0KPg0KPiBBbG9uZyB3aXRoIHNheWluZyBoZWxsbywgSSB3b3VsZCBsaWtlIHRvIGNvbnN1
bHQgYWJvdXQgYSBmYWlsdXJlIHRoYXQgDQo+IGlzIGhhcHBlbmluZyB0byBtZSB3aXRoIGEg
UEcgOS4yIGJhc2UgYW5kIHdpdGggYSB0YWJsZSB0aGF0IHdlaWdocyANCj4gMTE2R0IgYW5k
IGl0cyBpbmRleCAxM0diLCBtb3VudGVkIG9uIGEgTGludXggQ2VudG9zIDcuMiB3aXRoIDRD
b3JlIGFuZCANCj4gMzJSYW0uDQo+IFRoZSBmYWlsdXJlIG9jY3VycyBtYWlubHkgaW4gdGhh
dCBJIGV4ZWN1dGUgYSBWYWN1dW0gRnVsbCBvbiB0aGUgdGFibGUgDQo+IGFuZCBpdCBlbmRz
IGFmdGVyIDYgaG91cnMsIGJ1dCBpdCBkb2VzIG5vdCBjbGVhbiBhbnl0aGluZy4gV2hlbiAN
Cj4gY2hlY2tpbmcgdGhlIGRlYWQgdHVwbGVzIEkgcmVhbGl6ZSB0aGF0IHRoZXkgZm9sbG93
IHRoZSBzYW1lIGRpcnR5IA0KPiByZWNvcmRzIGluIHRoZSB0YWJsZS4gUkVGOiAodGFibGUg
b2YgNDIwTU0gcmVjb3JkcyB3aXRoIDIwTU0gZGVhZCB0dXBsZXMpDQo+DQo+IEkgaG9wZSB5
b3UgY2FuIGd1aWRlIG1lIGluIGZpbmRpbmcgYSBzb2x1dGlvbiB0byBjbGVhbiB0aGF0IHRh
YmxlLg0KPg0KPiBHcmVldGluZ3MgYW5kIG1hbnkgdGhhbmtzIHRvIHRoZSBQb3N0Z3Jlc3Fs
Lm9yZyBjb21tdW5pdHkNCj4gQXR0ZS4NCj4NCj4gLyoNCj4gKi8NCj4gLypFcmlrIFNlcnJh
bm8qLw0KPg0KDQpIaSBFcmlrLA0KDQpEb2VzIGl0IGVuZCBjbGVhbmx5IG9yIHdpdGggYW4g
ZXJyb3IgYWZ0ZXIgNiBob3Vycz8NCg0KRG8geW91IGhhdmUgZW5vdWdoIGRpc2sgc3BhY2Ug
Zm9yIHRoZSB2YWN1dW0gZnVsbD8gVGhlIG9sZCBhbmQgdGhlIG5ld2x5IA0Kd3JpdHRlbiBk
YXRhIGhhdmUgdG8gZXhpc3QgYXQgdGhlIHNhbWUgdGltZS4gT25seSBhZnRlciBhIHN1Y2Nl
c3NmdWwgDQp2YWN1dW1pbmcgdGhlIG9sZCBkYXRhIGdldCBkZWxldGVkLg0KDQpCVFcsIFBH
IDkuMiBoYXMgYmVlbiBvdXQgb2Ygc2VydmljZSBmb3IgcXVpdGUgc29tZSB0aW1lLiBPbmx5
IHZlcnNpb25zIA0KMTEgdG8gMTUgYXJlIHN1cHBvcnRlZCwgd2l0aCB0aGUgc3VwcG9ydCBm
b3IgdmVyc2lvbiAxMSBsYXN0aW5nIGxlc3MgDQp0aGFuIGEgeWVhci4NCg0KS2luZCBSZWdh
cmRzLA0KDQpIb2xnZXINCg0KLS0gDQpIb2xnZXIgSmFrb2JzLCBCZXJnaXNjaCBHbGFkYmFj
aCwgVGVsLiArNDktMTc4LTk3NTkwMTINCg0K
--------------q25ty16vW6gV5L7Yba6egP2o
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html>
  <head>
    <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DUTF=
-8">
  </head>
  <body>
    <div class=3D"moz-cite-prefix">Am 07.02.23 um 17:51 schrieb Erik
      Serrano:<br>
    </div>
    <blockquote type=3D"cite"
cite=3D"mid:CA+dvXXu2krLsS3K_GJkdrCT1hbu+G0rxAjh1KKot5TGrBpn8AA@mail.gmai=
l.com">
      <meta http-equiv=3D"content-type" content=3D"text/html; charset=3DU=
TF-8">
      <div dir=3D"ltr">Dear All,
        <div><br>
          Along with saying hello, I would like to consult about a
          failure that is happening to me with a PG 9.2 base and with a
          table that weighs 116GB and its index 13Gb, mounted on a Linux
          Centos 7.2 with 4Core and 32Ram.<br>
          The failure occurs mainly in that I execute a Vacuum Full on
          the table and it ends after 6 hours, but it does not clean
          anything. When checking the dead tuples I realize that they
          follow the same dirty records in the table. REF: (table of
          420MM records with 20MM dead tuples)<br>
          <br>
          I hope you can guide me in finding a solution to clean that
          table.<br>
          <br>
          Greetings and many thanks to the Postgresql.org community<br>
          Atte.<br clear=3D"all">
          <div>
            <div dir=3D"ltr" class=3D"gmail_signature"
              data-smartmail=3D"gmail_signature">
              <div dir=3D"ltr">
                <div>
                  <div dir=3D"ltr">
                    <div>
                      <div dir=3D"ltr">
                        <div><br>
                          <i><b><br>
                            </b></i></div>
                        <div><i><b><font size=3D"4">Erik Serrano</font></=
b></i></div>
                        <div><br>
                        </div>
                      </div>
                    </div>
                  </div>
                </div>
              </div>
            </div>
          </div>
        </div>
      </div>
    </blockquote>
    <p><br>
    </p>
    <p>Hi Erik,</p>
    <p>Does it end cleanly or with an error after 6 hours?</p>
    <p>Do you have enough disk space for the vacuum full? The old and
      the newly written data have to exist at the same time. Only after
      a successful vacuuming the old data get deleted.</p>
    <p>BTW, PG 9.2 has been out of service for quite some time. Only
      versions 11 to 15 are supported, with the support for version 11
      lasting less than a year.<br>
    </p>
    <p>Kind Regards,</p>
    <p>Holger<br>
    </p>
    <pre class=3D"moz-signature" cols=3D"72">--=20
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012</pre>
  </body>
</html>

--------------q25ty16vW6gV5L7Yba6egP2o--

--------------UheWNlWnOVqrvd0CzZRX8Kny--

--------------1XQa8LkwqzbzW36bhI30RNwp
Content-Type: application/pgp-signature; name="OpenPGP_signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="OpenPGP_signature"

-----BEGIN PGP SIGNATURE-----

wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCY+KCtgUDAAAAAAAKCRCKV5yTsxlhurGN
AJwNfvXNJ8zXMDVYZVt0keAgQdoqAgCfUBrH776Aqf1stQC/anhKAIopJNk=
=A63z
-----END PGP SIGNATURE-----

--------------1XQa8LkwqzbzW36bhI30RNwp--