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

From Corey Huinker
Subject Re: Statistics Import and Export
Date
Msg-id CADkLM=ff8BsPCvigT+xooPPBy4mCyu6pGdR=_e6ew=gR7bpCGA@mail.gmail.com
Whole thread Raw
In response to Re: Statistics Import and Export  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Responses Re: Statistics Import and Export
List pgsql-hackers
Yeah, this is pretty much what I meant by "functional" interface. But if
I said maybe the format implemented by the patch is maybe too close to
how we store the statistics, then this has exactly the same issue. And
it has other issues too, I think - it breaks down the stats into
multiple function calls, so ensuring the sanity/correctness of whole
sets of statistics gets much harder, I think.

Export functions was my original plan, for simplicity, maintenance, etc, but it seemed like I'd be adding quite a few functions, so the one view made more sense for an initial version. Also, I knew that pg_dump or some other stats exporter would have to inline the guts of those functions into queries for older versions, and adapting a view definition seemed more straightforward for the reader than function definitions.
 

pgsql-hackers by date:

Previous
From: Corey Huinker
Date:
Subject: Re: Statistics Import and Export
Next
From: wenhui qiu
Date:
Subject: Re: Support "Right Semi Join" plan shapes