Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gXoX8-00080I-9g for pgsql-admin@arkaria.postgresql.org; Fri, 14 Dec 2018 14:33:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gXoX6-0004te-W5 for pgsql-admin@arkaria.postgresql.org; Fri, 14 Dec 2018 14:33:40 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gXoX6-0004tX-OM for pgsql-admin@lists.postgresql.org; Fri, 14 Dec 2018 14:33:40 +0000 Received: from mx1.mailbox.org ([2001:67c:2050:104:0:1:25:1]) by magus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gXoX4-0003Pg-9Z for pgsql-admin@lists.postgresql.org; Fri, 14 Dec 2018 14:33:40 +0000 Received: from smtp2.mailbox.org (unknown [IPv6:2001:67c:2050:105:465:1:2:0]) (using TLSv1.2 with cipher ECDHE-RSA-CHACHA20-POLY1305 (256/256 bits)) (No client certificate requested) by mx1.mailbox.org (Postfix) with ESMTPS id C63E24973C; Fri, 14 Dec 2018 15:33:34 +0100 (CET) X-Virus-Scanned: amavisd-new at heinlein-support.de Received: from smtp2.mailbox.org ([80.241.60.241]) by spamfilter03.heinlein-hosting.de (spamfilter03.heinlein-hosting.de [80.241.56.117]) (amavisd-new, port 10030) with ESMTP id sLOLaZp9xPIb; Fri, 14 Dec 2018 15:33:33 +0100 (CET) Message-ID: Subject: Re: pg_attribute getting bloated in size From: Laurenz Albe To: Artem Tomyuk , Ron Cc: pgsql-admin@lists.postgresql.org Date: Fri, 14 Dec 2018 15:33:32 +0100 In-Reply-To: References: <2b31f655c7696125284523fa06695429f24d79f8.camel@cybertec.at> Organization: Cybertec Content-Type: text/plain; charset="UTF-8" Mime-Version: 1.0 Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Fri, 2018-12-14 at 14:21 +0200, Artem Tomyuk wrote: > пт, 14 дек. 2018 г. в 14:14, Ron : > > On 12/14/2018 05:29 AM, Laurenz Albe wrote: > > > Artem Tomyuk wrote: > > >> Why autovacuum cant delete those rows? > > > Either long running transactions (check pg_stat_activity) > > > or prepared transactions (check pg_prepared_xacts) > > > or stale replication slots (check pg_replication_slots). > > > > Would a manual "VACUUM FULL pg_attribute;" solve the problem? > > yes, it helps Only if the problems have been removed. Otherwise, VACUUM (FULL) won't help. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com