Postgres Pro
Downloads
Home   >   mailing lists

Re: Statistics Import and Export - Mailing list pgsql-hackers

From Corey Huinker
Subject Re: Statistics Import and Export
Date
Msg-id CADkLM=cG8=gde_KjGiQC_wt0K3knJCy_mwvd-sW=f=3M2eSrEg@mail.gmail.com
Whole thread Raw
In response to Re: Statistics Import and Export  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: Statistics Import and Export
List pgsql-hackers
Tree view


On Tue, Feb 25, 2025 at 9:00 PM Jeff Davis <pgsql@j-davis.com> wrote:
On Mon, 2025-02-24 at 09:54 -0500, Andres Freund wrote:
> Have you compared performance of with/without stats after these
> optimizations?

On unoptimized build with asserts enabled, dumping the regression
database:

  --no-statistics: 1.0s
  master:          3.6s
  v3j-0001:        3.0s
  v3j-0002:        1.7s

I plan to commit the patches soon.

Regards,
        Jeff Davis


+1 from me

We can still convert the "EXECUTE getAttributeStats" call to a Params call, but that involves creating an ExecuteSqlQueryParams(), which starts to snowball in the changes required.
 

pgsql-hackers by date:

Previous
From: Sutou Kouhei
Date:
Subject: Re: Make COPY format extendable: Extract COPY TO format implementations
Next
From: Srinath Reddy
Date:
Subject: Postmaster crashed during start