Re: [PATCHES] GIN improvements

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [PATCHES] GIN improvements
Дата
Msg-id 16080.1233625091@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [PATCHES] GIN improvements  (Teodor Sigaev <teodor@sigaev.ru>)
Ответы Re: [PATCHES] GIN improvements
Re: [PATCHES] GIN improvements
Список pgsql-hackers
Teodor Sigaev <teodor@sigaev.ru> writes:
> I'm very sorry, but v0.24 has a silly bug with not initialized value :(.
> New version is attached

I looked at this a little bit --- it needs proofreading ("VACUUME"?).

Do we really need an additional column in pgstat table entries in
order to store something that looks like it can be derived from the
other columns?  The stats tables are way too big already.

Also, I really think it's a pretty bad idea to make index cost
estimation depend on the current state of the index's pending list
--- that state seems far too transient to base plan choices on.
It's particularly got to be nuts to turn off indexscans entirely
if the pending list is "too full".  Having some lossy pages might
not be great but I don't believe it can be so bad that you should
go to a seqscan all the time.
        regards, tom lane


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: More FOR UPDATE/FOR SHARE problems
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Review: B-Tree emulation for GIN