Re: Statistics Import and Export

Thanks for the help. This has unblocked us! On Thu, May 22, 2025 at 8:25 AM Nathan Bossart wrote: > On Wed, May 21, 2025 at 04:53:17PM -0700, Jeff Davis wrote: > > On Wed, 2025-05-21 at 16:29 -0500, Nathan Bossart wrote: > >> I don't know precisely where that line might be, but in this case, > >

Re: Statistics Import and Export

Looks good to me. On Wed, May 21, 2025 at 9:08 AM Nathan Bossart wrote: > On Tue, May 20, 2025 at 10:32:39AM -0700, Hari Krishna Sunder wrote: > > Ah ya, forgot that reltuples are not always accurate. This sounds > > reasonable to me. > > Cool. Here is what I have stage

Re: Statistics Import and Export

Ah ya, forgot that reltuples are not always accurate. This sounds reasonable to me. On Mon, May 19, 2025 at 2:32 PM Nathan Bossart wrote: > On Mon, May 19, 2025 at 02:13:45PM -0700, Hari Krishna Sunder wrote: > > I think it would be better to revert 9879105 since there can be a > &g

Re: Statistics Import and Export

Sorry didn't know about the conference. I think it would be better to revert 9879105 since there can be a considerable number of true empty tables that we don’t need to process. --- Hari Krishna Sunder On Mon, May 19, 2025 at 9:51 AM Nathan Bossart wrote: > On Wed, May 14, 2025 at 01

Re: Statistics Import and Export

Gentle ping on this. --- Hari Krishna Sunder On Wed, May 14, 2025 at 1:30 PM Hari Krishna Sunder wrote: > Thanks Nathan. > Here is the patch with a comment. > > On Wed, May 14, 2025 at 8:53 AM Nathan Bossart > wrote: > >> On Tue, May 13, 2025 at 05:01:02PM -0700, H

Re: Statistics Import and Export

Thanks Nathan. Here is the patch with a comment. On Wed, May 14, 2025 at 8:53 AM Nathan Bossart wrote: > On Tue, May 13, 2025 at 05:01:02PM -0700, Hari Krishna Sunder wrote: > > We found a minor issue when testing statistics import with upgrading from > > versions older tha

Re: Statistics Import and Export

We found a minor issue when testing statistics import with upgrading from versions older than v14. (We have VACUUM and ANALYZE disabled) 3d351d916b20534f973eda760cde17d96545d4c4 changed the def

Re: Statistics Import and Export

Hari Krishna Sunder On Fri, Mar 7, 2025 at 7:43 PM Corey Huinker wrote: > I tried to generalize that requirement to all of >> {schema|data|statistics} for consistency, but that resulted in 9 >> options. >> > > 9 options that resolve to 3 boolean variables. It's no

Re: 回复：Re: 回复：Re: speed up pg_upgrade with large number of tables

The restore side speedups suggested by Yang seem reasonable and can potentially speed up the process. We can even go a bit further by starting the new postgres in a --binary-upgrade mode and skip some of these locks completely. On Sun, Jan 19, 2025 at 3:43 PM Nathan Bossart wrote: > On Mon, Jul