From: | Hari krishna Maddileti <hmaddileti(at)vmware(dot)com> |
---|---|
To: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Support for dumping extended statistics |
Date: | 2023-01-05 18:29:03 |
Message-ID: | MN2PR05MB68795FCDB5B560D350084753B6FA9@MN2PR05MB6879.namprd05.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi Team,
In order to restore dumped extended statistics (stxdndistinct, stxddependencies, stxdmcv) we need to provide input functions to parse pg_distinct/pg_dependency/pg_mcv_list strings.
Today we get the ERROR "cannot accept a value of type pg_ndistinct/pg_dependencies/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_list.
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 know if there any interest from postgres side.
Regards,
Hari Krishna
From | Date | Subject | |
---|---|---|---|
Next Message | Reid Thompson | 2023-01-05 18:44:20 | Re: Add the ability to limit the amount of memory that can be allocated to backends. |
Previous Message | Matthias van de Meent | 2023-01-05 18:19:07 | Re: New strategies for freezing, advancing relfrozenxid early |