| From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
|---|---|
| To: | Corey Huinker <corey(dot)huinker(at)gmail(dot)com> |
| Cc: | Bruce Momjian <bruce(at)momjian(dot)us>, jian he <jian(dot)universality(at)gmail(dot)com>, Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Nathan Bossart <nathandbossart(at)gmail(dot)com>, Magnus Hagander <magnus(at)hagander(dot)net>, Stephen Frost <sfrost(at)snowman(dot)net>, Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, Peter Smith <smithpb2250(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, alvherre(at)alvh(dot)no-ip(dot)org |
| Subject: | Re: Statistics Import and Export |
| Date: | 2024-12-21 00:16:45 |
| Message-ID: | 699e79d831276054266cb2475e072df18d081cf8.camel@j-davis.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, 2024-12-19 at 21:23 -0800, Jeff Davis wrote:
> > 0001-0005 - changes to pg_dump/pg_upgrade
>
> Attached is a version 36j...
The testing can use some work here. I noticed that if I take out the
stats entirely, the tests still pass, because pg_upgrade still gets the
same before/after result.
Also, we need some testing of the output and ordering of pg_dump.
Granted, in most cases problems would result in errors during the
reload. But we have those tests for other kinds of objects, so we
should have the tests for stats, too.
I like the description "STATISTICS DATA" because it differentiates from
the extended stats definitions. It might be worth differentiating
between "RELATION STATISTICS DATA" and "ATTRIBUTE STATISTICS DATA" but
I'm not sure if there's value in that.
But how did you determine what to use for the .tag and prefix? In the
output, it uses the form:
Name: STATISTICS DATA <name>; Type: STATISTICS DATA; ...
Should that be:
Name: <name>; Type: STATISTICS DATA; ...
Or:
Data for Name: ...; Name: ...; Type: STATISTICS DATA; ...
Or:
Statistics for Name: ...; Name: ...; Type: STATISTICS DATA; ...
Regards,
Jeff Davis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Guo | 2024-12-21 01:05:09 | Re: Eager aggregation, take 3 |
| Previous Message | Thomas Munro | 2024-12-21 00:05:21 | Re: Bug: mdunlinkfiletag unlinks mainfork seg.0 instead of indicated fork+segment |