From: Joshua D. Drake <jd@commandprompt.com>
To: Jan <pgsql.admin@j.mk-contact.de>
To: pgsql-admin@postgresql.org
Subject: Re: Long-running and non-finishing VACUUM ANALYZE on large table
Date: Fri, 2 Oct 2015 09:53:29 -0700
Message-ID: <560EB689.7040000@commandprompt.com> (raw)
In-Reply-To: <560EB550.5050501@j.mk-contact.de>
References: <560EB550.5050501@j.mk-contact.de>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On 10/02/2015 09:48 AM, Jan wrote:
> Hi everyone,
>
> I'm currently running PostgreSQL 9.3.6 on Ubuntu 14.04 Server and have
> severe problems to get one large table properly vacuumed (16,743,000,000
> reltuples).
16B in a single table? I am not surprised you are having issues.
> That is, autovacuum on that table does not finish (even after six days
> it is still running). To narrow down the problem, I stopped autovacuum,
> temporarily disabled it (but ONLY on that particular table; not a
> permanent solution, I know) and started a manual VACUUM ANALYZE on that
> table via PGAdmin instead. In analogy to the autovacuum, the manually
> started process is also running virtually endless (until I terminate it
> after some days) but PGadmin's verbose output (see below) tells me at
> least that it (apparently) tries to process the same table over and over
> again. I'm definitely not a Postgres guru, but this can't be the
> expected behaviour, even on such a big table, right?Did I overlook
> something?
178,956,763 row versions to be removed.
I have no doubt that it is taking what seems like forever.
I strongly suggest you partition this beast.
JD
--
Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jd@commandprompt.com, pgsql.admin@j.mk-contact.de
Subject: Re: Long-running and non-finishing VACUUM ANALYZE on large table
In-Reply-To: <560EB689.7040000@commandprompt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox