pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedVacuum full since 15 hours
2+ messages / 2 participants
[nested] [flat]
* Vacuum full since 15 hours
@ 2007-12-09 10:42 Hervé Piedvache <bill.footcow@gmail.com>
2007-12-09 16:32 ` Re: Vacuum full since 15 hours Heikki Linnakangas <heikki@enterprisedb.com>
0 siblings, 1 reply; 2+ messages in thread
From: Hervé Piedvache @ 2007-12-09 10:42 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Vacuum full since 15 hours
2007-12-09 10:42 Vacuum full since 15 hours Hervé Piedvache <bill.footcow@gmail.com>
@ 2007-12-09 16:32 ` Heikki Linnakangas <heikki@enterprisedb.com>
0 siblings, 0 replies; 2+ messages in thread
From: Heikki Linnakangas @ 2007-12-09 16:32 UTC (permalink / raw)
To: Hervé Piedvache <bill.footcow@gmail.com>; +Cc: pgsql-performance
Hervé Piedvache wrote:
> 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)
Yes, it probably will be. IIRC we even suggest doing that in the manual.
Another alternative is to run CLUSTER instead of VACUUM FULL. Increasing
maintenance_work_mem will make the index builds go faster.
Consider if you really need to run VACUUM FULL, or would plain VACUUM be
enough.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-12-09 16:32 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-12-09 10:42 Vacuum full since 15 hours Hervé Piedvache <bill.footcow@gmail.com>
2007-12-09 16:32 ` Heikki Linnakangas <heikki@enterprisedb.com>
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