Re: VACUUM FULL hangs - Mailing list pgsql-performance

From Marcin Mańk
Subject Re: VACUUM FULL hangs
Date
Msg-id 03ae01c64860$6039d160$0c67a8c0@maniek
Whole thread Raw
In response to VACUUM FULL hangs  (Marcin Mańk <marcin.mank@gmail.com>)
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:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: BETWEEN optimizer problems with single-value range
Next
From: "Kevin Grittner"
Date:
Subject: Re: BETWEEN optimizer problems with single-value