Re: Statistics Import and Export
| От | Corey Huinker |
|---|---|
| Тема | Re: Statistics Import and Export |
| Дата | |
| Msg-id | CADkLM=cG8=gde_KjGiQC_wt0K3knJCy_mwvd-sW=f=3M2eSrEg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Statistics Import and Export (Jeff Davis <pgsql@j-davis.com>) |
| Ответы |
Re: Statistics Import and Export
Re: Statistics Import and Export |
| Список | pgsql-hackers |
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 по дате отправления: