Re: [HACKERS] [PATCH] A hook for session start

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: [HACKERS] [PATCH] A hook for session start
Дата
Msg-id CAFj8pRAz+z_hVrm-2R-x_SyZ0A4GuHeQYSVafBZYG9_1kOWYFQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] [PATCH] A hook for session start  (Nico Williams <nico@cryptonector.com>)
Ответы Re: [HACKERS] [PATCH] A hook for session start  (Craig Ringer <craig@2ndquadrant.com>)
Re: [HACKERS] [PATCH] A hook for session start  (Nico Williams <nico@cryptonector.com>)
Список pgsql-hackers
Дерево обсуждения


2017-10-05 22:31 GMT+02:00 Nico Williams <nico@cryptonector.com>:
On Tue, Aug 01, 2017 at 03:36:23PM -0400, Peter Eisentraut wrote:
> On 7/21/17 13:14, Jim Mlodgenski wrote:
> > When I first saw this thread, my initial thought of a use case is to
> > prepare some key application queries so they are there and ready to go.
> > That would need to be before the ExecutorStart_hook or
> > ProcessUtility_hook if an app would just want to execute the prepared
> > statement.
>
> Isn't that what the preprepare extension does already?

more generic facility -> more useful

My use case is to pre-create TEMP schema elements that VIEWs, FUNCTIONs,
and TRIGGERs, might need.

It is better to work on GLOBAL TEMP tables.

Current TEMP tables, if you do it for any session has pretty significant overhead  - with possible risk of performance lost (system catalog bloat).

pretty significant performance issue of my customers are related to temp tables usage (under high load)

So often creating local temp tables is antipattern (in Postgres) unfortunately.

I am not sure, if we should to support this case more :( Probably is better, so it is hard to use local TEMP tables.

Regards

Pavel 

Nico
--


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] valgrind complains about WaitEventSetWaitBlock on HEAD(fe9ba28e)
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: [HACKERS] [PATCH] A hook for session start