[Pdns-users] Performance drop after upgrade from auth 3.4.11 to 4.0.4

[Klaus Darilion]

Am 21.09.2017 um 20:20 schrieb Aki Tuomi:
> Statements are supposed to prepared once, not per every query.

Indeed, that is the case, the "prepare" is only done once.

But I see that simple SELECTs are wrapped into transactions. Maybe this
is also a performance penalty:

regards
Klaus


LOG:  duration: 0.049 ms  statement: BEGIN
LOG:  duration: 0.276 ms  bind stmt1506068957225329: SELECT
content,ttl,prio,type,domain_id,disabled::int,name,auth::int FROM
records WHERE disabled=false and type=$1 and name=$2
DETAIL:  parameters: $1 = 'SOA', $2 =
'rr-types-dev.rc0-testing.dnssec-signiert.at'
LOG:  duration: 0.081 ms  execute stmt1506068957225329: SELECT
content,ttl,prio,type,domain_id,disabled::int,name,auth::int FROM
records WHERE disabled=false and type=$1 and name=$2
DETAIL:  parameters: $1 = 'SOA', $2 =
'rr-types-dev.rc0-testing.dnssec-signiert.at'
LOG:  duration: 0.043 ms  statement: COMMIT




LOG:  duration: 0.042 ms  statement: BEGIN
LOG:  duration: 0.263 ms  bind stmt1506069237650545: SELECT
content,ttl,prio,type,domain_id,disabled::int,name,auth::int FROM
records WHERE disabled=false and type=$1 and name=$2
DETAIL:  parameters: $1 = 'SOA', $2 =
'rr-types-dev.rc0-testing.dnssec-signiert.at'
LOG:  duration: 0.076 ms  execute stmt1506069237650545: SELECT
content,ttl,prio,type,domain_id,disabled::int,name,auth::int FROM
records WHERE disabled=false and type=$1 and name=$2
DETAIL:  parameters: $1 = 'SOA', $2 =
'rr-types-dev.rc0-testing.dnssec-signiert.at'
LOG:  duration: 0.038 ms  statement: COMMIT