Re: [0/4] Proposal of SE-PostgreSQL patches

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [0/4] Proposal of SE-PostgreSQL patches
Дата
Msg-id 19774.1210603957@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [0/4] Proposal of SE-PostgreSQL patches  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> Tom Lane wrote:
>> Hmm.  Is that really a good idea, compared to hard-wiring the checks
>> into nodeSeqscan and friends?

> My eyebrows went up when I read this too. Presumably, if it's hardwired 
> like you suggest then the planner can't take any account of the filter, 
> though. Do we want it to?

Well, the planner could have hardwired knowledge about the existence of
the hardwired filters --- if anything, that'd probably be easier than
hacking it to have a similar level of knowledge about generic-looking
function calls.  But in reality, since we don't know at plan time which
userid will execute the constructed plan, I'm not sure we could come up
with useful estimates anyway.
        regards, tom lane


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: constraint exclusion analysis caching
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Convert wal_sync_method to guc enum.