Re: FDW handling count(*) through AnalyzeForeignTable or other constant time push-down

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: FDW handling count(*) through AnalyzeForeignTable or other constant time push-down
Дата
Msg-id 13359.1456467682@sss.pgh.pa.us
обсуждение исходный текст
Ответ на FDW handling count(*) through AnalyzeForeignTable or other constant time push-down  ("Gabe F. Rudy" <rudy@goldenhelix.com>)
Ответы Re: FDW handling count(*) through AnalyzeForeignTable or other constant time push-down  ("Gabe F. Rudy" <rudy@goldenhelix.com>)
Список pgsql-hackers
Дерево обсуждения 
"Gabe F. Rudy" <rudy@goldenhelix.com> writes:
> Is there any way to convince Postgres FDW to leverage the analyze row counts or even the "double* totalRowCount"
returnedfrom the AcquireSampleRows callback from my AnalyzeForeignTable function so that it does not do a full-table
scanfor a COUNT(*) etc?
 

No.  In PG's view, ANALYZE-based row counts are imprecise by definition.
        regards, tom lane

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: insufficient qualification of some objects in dump files
Следующее
От: Tom Lane
Дата:
Сообщение: Re: insufficient qualification of some objects in dump files