Re: Having query cache in core
От
Pavel Stehule
Тема
Re: Having query cache in core
Дата
Msg-id
CAFj8pRDkoZUTtQ9+qy4LF=eOyBKj_ktj8ptsRd=p4btCRHm+WQ@mail.gmail.com
Ответ на
Re: Having query cache in core (Robert Haas)
Список
Дерево обсуждения
Having query cache in core Tatsuo Ishii <ishii@sraoss.co.jp>
Re: Having query cache in core Tom Lane <tgl@sss.pgh.pa.us>
Re: Having query cache in core Heikki Linnakangas <hlinnaka@iki.fi>
Re: Having query cache in core Tatsuo Ishii <ishii@sraoss.co.jp>
Re: Having query cache in core Michael Paquier <michael@paquier.xyz>
Re: Having query cache in core Tatsuo Ishii <ishii@sraoss.co.jp>
Re: Having query cache in core CK Tan <cktan@vitessedata.com>
Re: Having query cache in core Tatsuo Ishii <ishii@sraoss.co.jp>
Re: Having query cache in core Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
Re: Having query cache in core Tatsuo Ishii <ishii@sraoss.co.jp>
Re: Having query cache in core CK Tan <cktan@vitessedata.com>
Re: Having query cache in core Tatsuo Ishii <ishii@sraoss.co.jp>
Re: Having query cache in core CK Tan <cktan@vitessedata.com>
Re: Having query cache in core Andres Freund <andres@anarazel.de>
Re: Having query cache in core Hartmut Holzgraefe <hartmut.holzgraefe@gmail.com>
Re: Having query cache in core Hartmut Holzgraefe <hartmut.holzgraefe@gmail.com>
Re: Having query cache in core Tatsuo Ishii <ishii@sraoss.co.jp>
Re: Having query cache in core Hartmut Holzgraefe <hartmut.holzgraefe@gmail.com>
Re: Having query cache in core Tatsuo Ishii <ishii@sraoss.co.jp>
Re: Having query cache in core Laurenz Albe <laurenz.albe@cybertec.at>
Re: Having query cache in core Sergei Kornilov <sk@zsrv.org>
Re: Having query cache in core Hartmut Holzgraefe <hartmut.holzgraefe@gmail.com>
Re: Having query cache in core Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
RE: Having query cache in core "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Having query cache in core Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: Having query cache in core Tatsuo Ishii <ishii@sraoss.co.jp>
Re: Having query cache in core Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Re: Having query cache in core Hartmut Holzgraefe <hartmut.holzgraefe@gmail.com>
Re: Having query cache in core Robert Haas <robertmhaas@gmail.com>
Re: Having query cache in core Andres Freund <andres@anarazel.de>
Re: Having query cache in core Pavel Stehule <pavel.stehule@gmail.com>
Re: Having query cache in core Robert Haas <robertmhaas@gmail.com>
RE: Having query cache in core "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
2018-05-07 19:52 GMT+02:00 Robert Haas <robertmhaas@gmail.com>:
On Sun, May 6, 2018 at 10:32 PM, Tatsuo Ishii <ishii@sraoss.co.jp> wrote:
> Does anybody think having in-memory query result cache in core is a
> good idea? From the experience of implementing the feature in
> Pgpool-II, I would think this is not terribly hard job. But first of
> all I'm wondering if there's a demand for the feature.
Caching results doesn't seem very useful to me, but caching plans
does. I think the challenges are formidable, though.
My last customer has queries where planning time is 10 sec, unfortunately execution time in worst case (badly optimized is 200ms).
Can we introduce some planning cost to cache only expensive queries, or some hints for query plan control.
For interactive application only for one subset of queries the plan cache is interesting.
@1 There are long queries - the planning time is not significant (although can be high), and then plan cache is not important
@2 there are fast queries with fast planning time - usually we don't need plan cache too
@3 there are fast queries with long planning time - and then plan cache is very interesting - can be difficult to separate this case from @1.
Regards
Pavel
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
В списке pgsql-hackers по дате отправления
