Re: Vaccum Stalling
От | Brad Nicholson |
---|---|
Тема | Re: Vaccum Stalling |
Дата | |
Msg-id | 1184083000.5455.12.camel@bnicholson-desktop обсуждение исходный текст |
Ответ на | Re: Vaccum Stalling (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Vaccum Stalling
|
Список | pgsql-general |
On Tue, 2007-07-10 at 11:31 -0400, Tom Lane wrote: > Brad Nicholson <bnichols@ca.afilias.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? Not sure which one it's working on - there are 6 of them each are ~ 2.5GB -- Brad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp.
В списке pgsql-general по дате отправления: