Re: BUG #4812: statistics not available on tables containing only hstore column

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #4812: statistics not available on tables containing only hstore column
Дата
Msg-id 1421.1242661582@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #4812: statistics not available on tables containing only hstore column  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Ответы Re: BUG #4812: statistics not available on tables containing only hstore column
Список pgsql-bugs
Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
> ISTM we should not skip the analyze if run as a stand-alone ANALYZE. I'm
> not sure what problem the author of that comment envisioned with
> autovacuum, but resetting the live and dead tuple counters doesn't seem
> right to me.

I think that code probably originated at a time when palloc(0) threw an
error, and was meant to avoid any corner-case failures in the subsequent
logic.  I can't get very excited about the case --- it seems to me the
*real* fix for this complaint is to give hstore some ANALYZE support ---
but if you've tested that it behaves sanely with no columns I have no
objection to committing it.

            regards, tom lane

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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: BUG #4812: statistics not available on tables containing only hstore column
Следующее
От: hubert depesz lubaczewski
Дата:
Сообщение: distinct on doesn't fail without order by? why?