public inbox for [email protected]
help / color / mirror / Atom feedFrom: Corey Huinker <[email protected]>
To: David Rowley <[email protected]>
Cc: Ryohei Takahashi (Fujitsu) <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Can we use Statistics Import and Export feature to perforamance testing?
Date: Sat, 12 Apr 2025 04:29:42 -0400
Message-ID: <CADkLM=fV95NKw4x9pBtaXHtQP4=21nmjDBuv2XJm3ZiNgc0AKw@mail.gmail.com> (raw)
In-Reply-To: <CAApHDvozyyTc19zhnWSqMhvW_dqYJCCkdh5mo3DA65zEFPu8fg@mail.gmail.com>
References: <TY3PR01MB118914FCCBBDC126C34AA287382B52@TY3PR01MB11891.jpnprd01.prod.outlook.com>
<CAApHDvozyyTc19zhnWSqMhvW_dqYJCCkdh5mo3DA65zEFPu8fg@mail.gmail.com>
>
> at the *actual size* of the relation and takes that into account when
> scaling the statistics (see table_block_relation_estimate_size() in
> tableam.c). If the table sizes don't match between the two servers
> then there's no guarantees the planner will produce the same plan.
>
Sorry that I didn't see this thread until now. I would like to note that
table_block_relation_estimate_size() determines the actual size of the
relation by asking pg_class, and the relevant values there are set by
pg_restore_relation_stats().
view thread (2+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Can we use Statistics Import and Export feature to perforamance testing?
In-Reply-To: <CADkLM=fV95NKw4x9pBtaXHtQP4=21nmjDBuv2XJm3ZiNgc0AKw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox