Re: [HACKERS] Cached plans and statement generalization

Поиск
Список
Период
Сортировка
Искать
От
Andres Freund
Тема
Re: [HACKERS] Cached plans and statement generalization
Дата
в 20:38:26
Msg-id
9D2E3022-1DCE-45DB-92AF-B2B5C4842992@anarazel.de
Ответ на
Список
Дерево обсуждения
[HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Andres Freund <andres@anarazel.de>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Pavel Stehule <pavel.stehule@gmail.com>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] Cached plans and statement generalization Andres Freund <andres@anarazel.de>
Re: [HACKERS] Cached plans and statement generalization Douglas Doole <dougdoole@gmail.com>
Re: [HACKERS] Cached plans and statement generalization Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] Cached plans and statement generalization Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Andres Freund <andres@anarazel.de>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Andres Freund <andres@anarazel.de>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Thomas Munro <thomas.munro@enterprisedb.com>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Michael Paquier <michael.paquier@gmail.com>
RE: [HACKERS] Cached plans and statement generalization "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: [HACKERS] Cached plans and statement generalization Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] Cached plans and statement generalization Thomas Munro <thomas.munro@enterprisedb.com>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
RE: [HACKERS] Cached plans and statement generalization "Yamaji, Ryo" <yamaji.ryo@jp.fujitsu.com>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
RE: [HACKERS] Cached plans and statement generalization "Yamaji, Ryo" <yamaji.ryo@jp.fujitsu.com>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
RE: [HACKERS] Cached plans and statement generalization "Yamaji, Ryo" <yamaji.ryo@jp.fujitsu.com>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
RE: [HACKERS] Cached plans and statement generalization "Yamaji, Ryo" <yamaji.ryo@jp.fujitsu.com>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
RE: [HACKERS] Cached plans and statement generalization "Yamaji, Ryo" <yamaji.ryo@jp.fujitsu.com>
Re: [HACKERS] Cached plans and statement generalization Dmitry Dolgov <9erthalion6@gmail.com>
RE: [HACKERS] Cached plans and statement generalization "Yamaji, Ryo" <yamaji.ryo@jp.fujitsu.com>
Re: [HACKERS] Cached plans and statement generalization Dmitry Dolgov <9erthalion6@gmail.com>
RE: [HACKERS] Cached plans and statement generalization "Nagaura, Ryohei" <nagaura.ryohei@jp.fujitsu.com>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
RE: [HACKERS] Cached plans and statement generalization "Yamaji, Ryo" <yamaji.ryo@jp.fujitsu.com>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Thomas Munro <thomas.munro@gmail.com>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Thomas Munro <thomas.munro@gmail.com>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Thomas Munro <thomas.munro@gmail.com>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Heikki Linnakangas <hlinnaka@iki.fi>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Daniel Migowski <dmigowski@ikoffice.de>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Daniel Migowski <dmigowski@ikoffice.de>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Cached plans and statement generalization Daniel Gustafsson <daniel@yesql.se>
Re: [HACKERS] Cached plans and statement generalization Юрий Соколов <funny.falcon@gmail.com>
RE: [HACKERS] Cached plans and statement generalization "Nagaura, Ryohei" <nagaura.ryohei@jp.fujitsu.com>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: Re: [HACKERS] Cached plans and statement generalization David Steele <david@pgmasters.net>
Re: Re: Re: [HACKERS] Cached plans and statement generalization David Steele <david@pgmasters.net>
Re: [HACKERS] Cached plans and statement generalization Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Andres Freund <andres@anarazel.de>
Re: [HACKERS] Cached plans and statement generalization David Fetter <david@fetter.org>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization David Fetter <david@fetter.org>
Re: [HACKERS] Cached plans and statement generalization "David G. Johnston" <david.g.johnston@gmail.com>
Re: [HACKERS] Cached plans and statement generalization Serge Rielau <serge@rielau.com>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Serge Rielau <serge@rielau.com>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Serge Rielau <serge@rielau.com>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Doug Doole <ddoole@salesforce.com>
Re: [HACKERS] Cached plans and statement generalization Andres Freund <andres@anarazel.de>
Re: [HACKERS] Cached plans and statement generalization Doug Doole <ddoole@salesforce.com>
Re: [HACKERS] Cached plans and statement generalization Andres Freund <andres@anarazel.de>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization "Finnerty, Jim" <jfinnert@amazon.com>
Re: [HACKERS] Cached plans and statement generalization Doug Doole <ddoole@salesforce.com>
Re: [HACKERS] Cached plans and statement generalization Serge Rielau <serge@rielau.com>
Re: [HACKERS] Cached plans and statement generalization Doug Doole <ddoole@salesforce.com>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: [HACKERS] Cached plans and statement generalization Konstantin Knizhnik <k.knizhnik@postgrespro.ru>


On May 12, 2017 12:50:41 AM PDT, Konstantin Knizhnik  wrote:

>Definitely changing session context (search_path, date/time format,
>...) 
>may cause incorrect behavior of cached statements.
>Actually you may get the same problem with explicitly prepared 
>statements (certainly, in the last case, you better understand what 
>going on and it is your choice whether to use or not to use prepared 
>statement).
>
>The fact of failure of 7 regression tests means that autoprepare can 
>really change behavior of existed program. This is why my suggestion is
> 
>to switch off this feature by default.

I can't see us agreeing with this feature unless it actually reliably works, even if disabled by default.

Andres
-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.


В списке pgsql-hackers по дате отправления
От: Joe Conway
Дата:
Сообщение: Re: [HACKERS] Hash Functions
От: Bruce Momjian
Дата:
FAQ