From: Hervé Piedvache <bill.footcow@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Vacuum full since 15 hours
Date: Sun, 9 Dec 2007 11:42:41 +0100
Message-ID: <200712091142.41651.bill.footcow@gmail.com> (raw)
Hi,
I have a small question ... right now on a 8.1.10 version of PostgreSQL I'm
doing a vacuum full verbose anaylze a table with 60 304 340 rows in 1155791
pages and there were 16 835 144 unused item pointers inside and 5 index.
After the first treatment of the index (appeared in the verbose) ... the
vacuum is still working now since 15 hours ... There is none other activity
on this server ... it's a replication server ... so the vacuum is locking
most of the replication queries ...
What can I do to get this doing quicker ...?
It's a 8Gb server ... with a RAID 10 ... my maintenance_work_mem = 25600.
Any idea ?
I'm sure that if I delete all the index an rebuild them by hand it'll be
really quicker ! (done on another replication server ... took 20 min)
regards,
--
Hervé Piedvache
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-performance@postgresql.org
Cc: bill.footcow@gmail.com
Subject: Re: Vacuum full since 15 hours
In-Reply-To: <200712091142.41651.bill.footcow@gmail.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