From: =?utf-8?q?Herv=C3=A9_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
User-Agent: KMail/1.9.6 (enterprise 0.20070907.709405)
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200712091142.41651.bill.footcow@gmail.com>

Hi,

I have a small question ... right now on a 8.1.10 version of PostgreSQL I'm=
=20
doing a  vacuum full verbose anaylze a table with 60 304 340 rows in 115579=
1=20
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=20
vacuum is still working now since 15 hours ... There is none other activity=
=20
on this server ... it's a replication server ... so the vacuum is locking=20
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 =3D 25600.

Any idea ?
I'm sure that if I delete all the index an rebuild them by hand it'll be=20
really quicker ! (done on another replication server ... took 20 min)

regards,
=2D-=20
Herv=C3=A9 Piedvache