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

[Aki Tuomi]

On 22.09.2017 11:35, Klaus Darilion wrote:
>
> 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
>
>

To my inexpert eye it seems that in your original post, 4.1 was fastest
of the lot, so the database begin/commit + prepare cannot really explain
this since this has not been removed in 4.1?

Aki