Re: VACUUM FULL hangs

From: Marcin Mańk
Subject: Re: VACUUM FULL hangs
Date: ,
Msg-id: 03ae01c64860$6039d160$0c67a8c0@maniek
(view: Whole thread, Raw)
In response to: VACUUM FULL hangs  (Marcin Mańk)
List: pgsql-performance

> I'm a bit puzzled as to how you managed to get so much free space at the
> start of the table. Did the replication work on the second try?

It actually worked on third try, I guess.

> OK, so you might well be getting the vacuum writing one page, then WAL,
> then vacuum, etc. That will mean the disk spends most of its time
> seeking back and fore. How many disks do you have, and is the WAL on a
> separate set of disks?

It is 2 spindles software RAID1 . Till now there were no performance
problems with this machine that would mandate trying anything more fancy,
this machine is low traffic.

Greetings
Marcin Mańk



pgsql-performance by date:

From: Jan de Visser
Date:
Subject: Re: Slow SELECTS after large update cycle
From: Tom Lane
Date:
Subject: Re: BETWEEN optimizer problems with single-value