From: Hari krishna Maddileti <hmaddileti@vmware.com>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>,
	"pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>
Subject: Support for dumping extended statistics
Thread-Topic: Support for dumping extended statistics
Thread-Index: AQHZITJBgP44nSWfwUKD8vMaewyHAQ==
Date: Thu, 5 Jan 2023 18:29:03 +0000
Message-ID:
 <MN2PR05MB68795FCDB5B560D350084753B6FA9@MN2PR05MB6879.namprd05.prod.outlook.com>
Accept-Language: en-US
Content-Language: en-IN
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?us-ascii?Q?/aBinYnxuiZmABHYz1u2uTD6Mx3UaItO88DfA8jnRNMO0J5HPd4vpUf/mYN3?=
 =?us-ascii?Q?9Vmn1M1uQJmIlAg2MTjoCeZ0c4v/p2Exz6uYoI3dgfbVEH0te2UF0rXW/jXJ?=
 =?us-ascii?Q?wHl9WFVkm5HM5ZiXXKReHCZPQ6Bd5QBdE0cp6gkvplRnG7fzpr+PGoAtRmw9?=
 =?us-ascii?Q?5HmeL0HNXVmdDk4SYjUa89lrXz3GefeOkCr4tOiCccjNyuC94Ysbli2rrEkC?=
 =?us-ascii?Q?YRARh60DDmesen92QQALI/iVqJifMEEJQCgS6d6iUafubdbNUhaO5xVF0HHE?=
 =?us-ascii?Q?l3DDYVBSW88nUH36fW6KGiqtThXCbhJSSqyvZ1mnTehWzuqGVl9SMJ1LIjoP?=
 =?us-ascii?Q?ht7RmtrkpctBuCO/+6Wn5X5BWvRoJk9GoXWfJ1RgKwRX11Gy82RrMv6WKox/?=
 =?us-ascii?Q?IWmDHJ1WaXyRsR9dZ955qzI2SkWZk/HQmJjz4dv6RAM01IEWwMY0kbpdcILc?=
 =?us-ascii?Q?3mkusdtkZMB6Sc0Mgh2Ihy15MDLe0l1olK2GPJfFuDbZT5hE9rKCrnDIC482?=
 =?us-ascii?Q?JRkjxkV+0zPxbZhSKinFJgF5L6I0awePQSbksiTNhC0tczlje+yOOEnKketI?=
 =?us-ascii?Q?OpgZGQsrlnbIXNZ8V40sK2lCuF1Xz8x7oN3VO1cUmApelCEkcv4etmxhES7o?=
 =?us-ascii?Q?HVEftNlT2PT+acIer7zrYRQnx5DZf+F7RBXPdn3isb0HzU8U4r9wiYyvM56O?=
 =?us-ascii?Q?Bj66eQITzSQJdL1v906C2H5HrCMwAsyHU0EzaIxmR9SAHjTm6ykqHPsTl00J?=
 =?us-ascii?Q?zv+nDCQE2DDOY2OfP/2XfH/4gZzODtXNLCOOMzdmiMIOEpUAY3a5PJWVqtBs?=
 =?us-ascii?Q?1xEcVzHtuxFznrNcXbM6+5p/qEnPKigRCooG5tHvKL/py7N1qdQxJtVDkIth?=
 =?us-ascii?Q?ZlR9QHJh2WXLZXyay7n23GbO+Bq3FWfhxBiHLG1CBeByR4Qx8GsRGgJy7frh?=
 =?us-ascii?Q?0L1sgdQ/xNXTeU5gcds/7kT/TYEqY4zTB6RaQl+2mCjFux2iUZd2nS1T4HUK?=
 =?us-ascii?Q?uhmzDU4h1CT8syj0aKwdSe6Rh/PTRqEfWKGdHtu6ct8IY2UbDyVJpoc1IJ78?=
 =?us-ascii?Q?bOc0pdf/mDXXD0zQKQwz/cr06/oYGOydDWdssukmnXtednuiRQ8CFGUo8VuR?=
 =?us-ascii?Q?SVJJ9it77up1vyZ11x03IjzXa8K1byTucpewc/aJbLSaxUnDcSoLXMOdk9UQ?=
 =?us-ascii?Q?Kv15cFNFXY/iCOkqqm8ZGxi56Lrwqh+FkFp5DE8Fqi0gXtfyyYSXtM4lDwKh?=
 =?us-ascii?Q?hhbcyA1UV4KSy7mueTUSZe7jYsPr6uHLgsvQMYKE6+1gQvIPDa9a6KLvfgyN?=
 =?us-ascii?Q?4TrP0lsCRHvX27+P1X58+ZKAphTuOEmpEWU/WRCXTa+OD34esOBkWth6XRhE?=
 =?us-ascii?Q?6O+ZS6ACG7nKM5vq/zjGC5nwtvEvJWpN2RpSM6vgWzhYztX7AV/5oWfxg15c?=
 =?us-ascii?Q?Ix2YMnf1dJYXwlwP3OKWb3mE4ELo0D2M9fnOAr+vI2JzuaRhaHJlnXi3rmeq?=
 =?us-ascii?Q?X2jsGWwKNhQsnXRa/miXJ+mP9Ei88vKXB26HaTtVRkgW+Ri0ya/fUGWmi6qQ?=
 =?us-ascii?Q?OIwxrhGGWJLMTYv/Pth/xB9vdJtTZUqTv//UstGNOyo9/Z4Q570mC5I9/GKN?=
 =?us-ascii?Q?Lk2QyZB5owLrANLohHFuJhd+b+xyJ3dfgZzD/tCc8m1GCq1MSiLVKHDsnDwZ?=
 =?us-ascii?Q?mz6eNQ=3D=3D?=
Content-Type: multipart/alternative;
	boundary="_000_MN2PR05MB68795FCDB5B560D350084753B6FA9MN2PR05MB6879namp_"
MIME-Version: 1.0
X-OriginatorOrg: vmware.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: MN2PR05MB6879.namprd05.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: a8894203-860a-44fe-6536-08daef4ab8b1
X-MS-Exchange-CrossTenant-originalarrivaltime: 05 Jan 2023 18:29:03.0973
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: b39138ca-3cee-4b4a-a4d6-cd83d9dd62f0
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: jyk7o9hmlJQCNeZok518uHKNHukteFbxps+YgFGd4rs1fNIns3Bs+1rZsQSGkF3DWjb8MqWfC/USarRUhvXhxg==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: DM5PR05MB3546
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: <https://www.postgresql.org/message-id/MN2PR05MB68795FCDB5B560D350084753B6FA9%40MN2PR05MB6879.namprd05.prod.outlook.com>
Precedence: bulk

--_000_MN2PR05MB68795FCDB5B560D350084753B6FA9MN2PR05MB6879namp_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi Team,

In order to restore dumped extended statistics (stxdndistinct, stxddependen=
cies, stxdmcv) we need to provide input functions to parse pg_distinct/pg_d=
ependency/pg_mcv_list strings.

Today we get the ERROR "cannot accept a value of type pg_ndistinct/pg_depen=
dencies/pg_mcv_list" when we try to do an insert of any type.

Approch tried:
- Using yacc grammar file (statistics_gram.y) to parse the input string to =
its internal format for the types pg_distinct and pg_dependencies
- We are just calling byteain() for serialized input text of type pg_mcv_li=
st.

Currently the changes are working locally,  I would like to push the commit=
 changes to upstream if there any usecase for postgres.   Would like to kno=
w if there any interest from postgres side.

Regards,
Hari Krishna

--_000_MN2PR05MB68795FCDB5B560D350084753B6FA9MN2PR05MB6879namp_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" xmlns:w=3D"urn:sc=
hemas-microsoft-com:office:word" xmlns:m=3D"http://schemas.microsoft.com/of=
fice/2004/12/omml" xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;
	mso-fareast-language:EN-US;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	mso-fareast-language:EN-US;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
	{page:WordSection1;}
--></style>
</head>
<body lang=3D"EN-IN" link=3D"#0563C1" vlink=3D"#954F72" style=3D"word-wrap:=
break-word">
<div class=3D"WordSection1">
<p class=3D"MsoNormal"><span lang=3D"EN-US">Hi Team,<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">In order to restore dumped exte=
nded statistics (stxdndistinct, stxddependencies, stxdmcv) we need to provi=
de input functions to parse pg_distinct/pg_dependency/pg_mcv_list strings.<=
o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">Today we get the ERROR &quot;ca=
nnot accept a value of type pg_ndistinct/pg_dependencies/pg_mcv_list&quot; =
when we try to do an insert of any type.<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">Approch tried:<o:p></o:p></span=
></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">- Using yacc grammar file (stat=
istics_gram.y) to parse the input string to its internal format for the typ=
es pg_distinct and pg_dependencies<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">- We are just calling byteain()=
 for serialized input text of type pg_mcv_list.<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">Currently the changes are worki=
ng locally, &nbsp;I would like to push the commit changes to upstream if th=
ere any usecase for postgres.&nbsp; &nbsp;Would like to know if there any i=
nterest from postgres side.<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">Regards,<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">Hari Krishna<o:p></o:p></span><=
/p>
</div>
</body>
</html>

--_000_MN2PR05MB68795FCDB5B560D350084753B6FA9MN2PR05MB6879namp_--