| From: | Marcin Mańk <marcin(dot)mank(at)gmail(dot)com> |
|---|---|
| To: | |
| Cc: | <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: VACUUM FULL hangs |
| Date: | 2006-03-15 18:43:35 |
| Message-ID: | 03ae01c64860$6039d160$0c67a8c0@maniek |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2006-03-15 18:48:51 | Re: BETWEEN optimizer problems with single-value |
| Previous Message | Andreas Kretschmer | 2006-03-15 18:17:35 | Re: BETWEEN optimizer problems with single-value range |