From: Boris S. <boris@splet.net>
To: pgsql-admin@postgresql.org
Subject: High CPU usage from a vacuum process but does nothing
Date: Wed, 4 Oct 2017 19:28:35 +0200
Message-ID: <ca07e0e6-d51b-720b-337f-e5f5e053e533@infosplet.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
After migrating the server to a bigger machine, I'm noticing an odd
behaviour. If I begin vacuuming manually, it starts OK:
<snip>
0 pages are entirely empty.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO: analyzing "public.table024484"
INFO: "table024484": scanned 111123 of 111123 pages, containing 4909226
live rows and 0 dead rows; 150000 rows in sample, 4909226 estimated
total rows
But then it gets stuck indefinitely with high CPU usage and command
never exits. kill -TERM isn't helping, process stays on with ~99% CPU
usage. Stracing this process gets me just:
strace: Process 102011 attached
strace: [ Process PID=102011 runs in x32 mode. ]
Which is an odd message, all other processes give normal strace output.
latest pgsql 9.5 (same on old and new machine)
Ubuntu 16.04
Values in "cat /proc/102011/io" stay the same.
Autovacuum and other processes, queries aren't affected and can be
straced normally. Disk IO is low (checked with iostat)
Any ideas on what else to try?
--
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: boris@splet.net
Subject: Re: High CPU usage from a vacuum process but does nothing
In-Reply-To: <ca07e0e6-d51b-720b-337f-e5f5e053e533@infosplet.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