Re: Vaccum Stalling

Hello

I have similar problem with vacuum on 8.1

I have 256M table. pgstattuple reports 128M free. I stopped vacuum
after 1hour (maintenance_work_mem = 160M). I had not more time.

Regards
Pavel Stehule

2007/7/10, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info> writes:
> > On Tue, 2007-07-10 at 11:19 -0400, Tom Lane wrote:
> >> Oh, I forgot to mention --- you did check that vacuum_mem is set to
> >> a pretty high value, no? Else you might be doing a lot more
> >> btbulkdelete scans than you need to.
>
> > What would you define as high for 7.4? I bumped it up to ~ 245mbs
>
> That sounds like plenty --- you only need 6 bytes per dead tuple,
> so that should be enough to handle all your 15-20M dead tuples in
> one scan.
>
> How big is this index again?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/
>