Re: autovacuum and immediate shutdown issues
От | Brad Nicholson |
---|---|
Тема | Re: autovacuum and immediate shutdown issues |
Дата | |
Msg-id | 1255979385.4316.67.camel@bnicholson-desktop обсуждение исходный текст |
Ответ на | Re: autovacuum and immediate shutdown issues (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: autovacuum and immediate shutdown issues
Re: autovacuum and immediate shutdown issues |
Список | pgsql-general |
On Mon, 2009-10-19 at 15:01 -0400, Tom Lane wrote: > Brad Nicholson <bnichols@ca.afilias.info> writes: > > autoanalyze will automatically analyze new tables when they don't have > > stats. It seems logical that it should handle this case where the table > > also does not have stats. > > It will autoanalyze once a sufficient number of inserts have occurred. > The effect of a crash is just to reset the inserts-since-last-analyze > counters. You really haven't made the case why that's so awful that > we need to do things that are unpleasant along other dimensions in order > to avoid it. (The only ways of avoiding it that I can see would result > in very significant overhead added to the stats collection mechanism.) What about the question that Scott and I both asked - what about query plans. Will they be affected? If so, you could have a table that does not get updated, that no longer generates relevant query plans, and won't until manual intervention. -- Brad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp.
В списке pgsql-general по дате отправления: