Re: Can we use Statistics Import and Export feature to perforamance testing? - Mailing list pgsql-hackers

From Corey Huinker
Subject Re: Can we use Statistics Import and Export feature to perforamance testing?
Date
Msg-id CADkLM=fV95NKw4x9pBtaXHtQP4=21nmjDBuv2XJm3ZiNgc0AKw@mail.gmail.com
Whole thread Raw
In response to Re: Can we use Statistics Import and Export feature to perforamance testing?  (David Rowley <dgrowleyml@gmail.com>)
Responses Re: Can we use Statistics Import and Export feature to perforamance testing?
List pgsql-hackers
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().

pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: ci: Allow running mingw tests by default via environment variable
Next
From: Corey Huinker
Date:
Subject: Re: Can we use Statistics Import and Export feature to perforamance testing?