Re: [HACKERS] Cached plans and statement generalization - Mailing list pgsql-hackers

From Tsunakawa, Takayuki
Subject Re: [HACKERS] Cached plans and statement generalization
Date
Msg-id 0A3221C70F24FB45833433255569204D1F6EB258@G01JPEXMBYT05
Whole thread Raw
In response to Re: [HACKERS] Cached plans and statement generalization  (Konstantin Knizhnik <k.knizhnik@postgrespro.ru>)
Responses Re: [HACKERS] Cached plans and statement generalization
List pgsql-hackers
From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Konstantin
> Knizhnik
> Well, first of all I want to share results I already get: pgbench with default
> parameters,  scale 10 and one connection:
> 
> So autoprepare is as efficient as explicit prepare and can increase
> performance almost two times.

This sounds great.

BTW, when are the autoprepared statements destroyed?  Are you considering some upper limit on the number of prepared
statements?

Regards
Takayuki Tsunakawa





pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: [HACKERS] Separation walsender & normal backends
Next
From: 'Bruce Momjian'
Date:
Subject: Re: [HACKERS] PG 10 release notes