Re: TODO idea - implicit constraints across child tables with a common column as primary key (but obviously not a shared index)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: TODO idea - implicit constraints across child tables with a common column as primary key (but obviously not a shared index)
Дата
Msg-id 23870.1177390960@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: TODO idea - implicit constraints across child tables with a common column as primary key (but obviously not a shared index)  (Gregory Stark <stark@enterprisedb.com>)
Ответы Re: TODO idea - implicit constraints across child tables with a common column as primary key (but obviously not a shared index)  (Gregory Stark <stark@enterprisedb.com>)
Список pgsql-hackers
Gregory Stark <stark@enterprisedb.com> writes:
> The main data from the statistics that's of interest here are the extreme
> values of the histogram. If we're not interested in any values in that range
> then we can exclude the partition entirely.

Except that there is *no* guarantee that the histogram includes the
extreme values --- to promise that would require ANALYZE to scan every
table row.
        regards, tom lane


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

Предыдущее
От: ITAGAKI Takahiro
Дата:
Сообщение: Any incompatibility in pg_enc between 8.2 and 8.3?
Следующее
От: "Magnus Hagander"
Дата:
Сообщение: Re: [pgsql-advocacy] Wild idea: 9.0?