Re: [PATCHES] GIN improvements

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: [PATCHES] GIN improvements
Дата
Msg-id 1232561271.23793.46.camel@jdavis
обсуждение исходный текст
Ответ на Re: [PATCHES] GIN improvements  (Teodor Sigaev <teodor@sigaev.ru>)
Ответы Re: [PATCHES] GIN improvements  (Teodor Sigaev <teodor@sigaev.ru>)
Список pgsql-hackers
On Wed, 2009-01-21 at 15:06 +0300, Teodor Sigaev wrote:
> Done. Now GIN counts number of pending tuples and pages and stores they on 
> metapage. Index cleanup could start during normal insertion in two cases:
> - number of pending tuples is too high to keep guaranteed non-lossy tidbitmap
> - pending page's content doesn't fit into work_mem.

Great, thanks. I will take a look at this version tonight.

Because time is short, I will mark it as "Ready for committer review"
now. I think all of the major issues have been addressed, and I'll just
be looking at the code and testing it.

> BTW, gincostestimate could use that information for cost estimation, but is 
> index opening and metapge reading in amcostestimate acceptable?

That sounds reasonable to me. I think that's what the index-specific
cost estimators are for. Do you expect a performance impact?

Regards,Jeff Davis



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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [PATCH] EnableDisableTrigger Cleanup & Questions
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: FWD: Re: Updated backslash consistency patch