Re: Potential autovacuum optimization: new tables

Поиск
Список
Период
Сортировка
От Joshua Berkus
Тема Re: Potential autovacuum optimization: new tables
Дата
Msg-id 238109055.55809.1350160007233.JavaMail.root@agliodbs.com
обсуждение исходный текст
Ответ на Re: Potential autovacuum optimization: new tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> Ah.  Okay, maybe we can agree that that wasn't a good idea.

Oh, I'd say there's no question it was a mistake.  We just didn't have the data at the time to realize it.

> I don't really see that we need to bend over backwards to exactly
> match
> some data points that you made up out of thin air.  How about
> ceil(sqrt(N)) to start with?

We can start with anything, including Jeff Jane's equation (for my part, I think sqrt(N) will result in analyzing very
largetables a bit too often) The tough part will be coming up with some way to test it.
 

--Josh



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Joshua Berkus
Дата:
Сообщение: Re: Deprecating RULES
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Optimizer regression