Re: Support for dumping extended statistics

2023-02-13 Thread Andres Freund
Hi, On 2023-02-01 04:38:17 +, Hari krishna Maddileti wrote: > Thanks for the update, I have attached the updated patch with > meson compatible and addressed warnings from make file too. This patch consistently crashes in CI:

Re: Support for dumping extended statistics

2023-02-01 Thread Tom Lane
Tomas Vondra writes: > On 1/7/23 03:39, Bruce Momjian wrote: >> There is certainly interest in allowing the optimizer statistics to be >> dumped and reloaded. This could be used by pg_restore and pg_upgrade. > Indeed, although I think it'd be better to deal with regular statistics > (which is

Re: Support for dumping extended statistics

2023-02-01 Thread Tomas Vondra
On 1/7/23 03:39, Bruce Momjian wrote: > On Thu, Jan 5, 2023 at 06:29:03PM +, Hari krishna Maddileti wrote: >> Hi Team, >> In order to restore dumped extended statistics (stxdndistinct, >> stxddependencies, stxdmcv) we need to provide input functions to parse >>

Re: Support for dumping extended statistics

2023-02-01 Thread Justin Pryzby
On Wed, Feb 01, 2023 at 04:38:17AM +, Hari krishna Maddileti wrote: > Hi Justin, > Thanks for the update, I have attached the updated patch with > meson compatible and addressed warnings from make file too. Thanks - I see it compiles now under both build systems. But

Re: Support for dumping extended statistics

2023-01-31 Thread Hari krishna Maddileti
+ pgsql-hackers Hi Justin, Thanks for the update, I have attached the updated patch with meson compatible and addressed warnings from make file too. On 15/01/23, 2:27 AM, "Justin Pryzby" wrote: !! External Email On Tue, Jan 10, 2023 at 11:28:36AM +, Hari krishna

Re: Support for dumping extended statistics

2023-01-31 Thread Hari krishna Maddileti
Hi Justin, Thanks for the update, I have attached the updated patch with meson compatible and addressed warnings from make file too. On 15/01/23, 2:27 AM, "Justin Pryzby" wrote: !! External Email On Tue, Jan 10, 2023 at 11:28:36AM +, Hari krishna Maddileti wrote: >

Re: Support for dumping extended statistics

2023-01-14 Thread Justin Pryzby
On Tue, Jan 10, 2023 at 11:28:36AM +, Hari krishna Maddileti wrote: > Thanks Team for showing interest. > > Please find the attached patch, which uses the same approach as mentioned in > previous email to implement input functions to parse pg_distinct, > pg_dependency and pg_mcv_list

Re: Support for dumping extended statistics

2023-01-10 Thread Hari krishna Maddileti
To: Hari krishna Maddileti Cc: PostgreSQL Hackers Subject: Re: Support for dumping extended statistics !! External Email On Thu, Jan 5, 2023 at 06:29:03PM +, Hari krishna Maddileti wrote: > Hi Team, > In order to restore dumped extended statistics (stxdndistinct, > stxddependencies

Re: Support for dumping extended statistics

2023-01-06 Thread Bruce Momjian
On Thu, Jan 5, 2023 at 06:29:03PM +, Hari krishna Maddileti wrote: > 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

Support for dumping extended statistics

2023-01-05 Thread Hari krishna Maddileti
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