Re: On the need for a snapshot in exec_bind_message()

Поиск
Список
Период
Сортировка
От Daniel Wood
Тема Re: On the need for a snapshot in exec_bind_message()
Дата
Msg-id 595268113.627570.1536186760616@connect.xfinity.com
обсуждение исходный текст
Ответ на Re: On the need for a snapshot in exec_bind_message()  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: On the need for a snapshot in exec_bind_message()  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> >     exec_bind_message()
> >         PushActiveSnapshot(GetTransactionSnapshot());
> 
> > If there were no input functions, that needed this, nor reparsing or
> > reanalyzing needed, and we knew this up front, it'd be a huge win.
> 
> Unfortunately, that's not the case, so I think trying to get rid of
> this call is a nonstarter.

Queries stop getting re-optimized after 5 times, unless better plans are to be had.  In the absence of schema changes
orchanging search path why is the snapshot needed?
 

- Dan


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: *_to_xml() should copy SPI_processed/SPI_tuptable
Следующее
От: Tom Lane
Дата:
Сообщение: Re: unaccent(text) fails depending on search_path (WAS: pg_upgrade fails saying function unaccent(text) doesn't exist)