Re: [PATCH] postgres_fdw extension support

Поиск
Список
Период
Сортировка
От Paul Ramsey
Тема Re: [PATCH] postgres_fdw extension support
Дата
Msg-id etPan.55ae8f85.625558ec.4a53@Butterfly.local
обсуждение исходный текст
Ответ на Re: [PATCH] postgres_fdw extension support  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [PATCH] postgres_fdw extension support  (Paul Ramsey <pramsey@cleverelephant.ca>)
Список pgsql-hackers
On July 21, 2015 at 11:22:12 AM, Tom Lane (tgl@sss.pgh.pa.us) wrote:
> So: yes to a local cache of all forwardable functions/ops, populated in full the first time through (does that speak maybe to using a binary search on a sorted list instead of a hash, since I only pay the sort price once and am not doing any insertions?). And then we just hold it until the connection goes away. 

No, *not* populated first-time-through, because that won't handle any of
the CREATE, DROP, or UPGRADE cases. It's also doing a lot of work you
might never need. I was thinking of "populate on demand", that is, first
time you need to know whether function X is shippable, you find that out
and then cache the answer (whether it be positive or negative).

Roger that. Off to the races..

P

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: [PATCH] postgres_fdw extension support
Следующее
От: Fabien COELHO
Дата:
Сообщение: Re: pgbench stats per script & other stuff