public inbox for [email protected]  

help / color / mirror / Atom feed

From: PG Bug reporting form <[email protected]>
To: [email protected]
Cc: [email protected]
Subject: BUG #19529: Documentation appears inconsistent with pg_dump --statistics behavior for CREATE STATISTICS objects
Date: Fri, 19 Jun 2026 07:17:44 +0000
Message-ID: <[email protected]> (raw)

The following bug has been logged on the website:

Bug reference:      19529
Logged by:          Igi Izumi
Email address:      [email protected]
PostgreSQL version: 19beta1
Operating system:   Rocky Linux 10.2 x86_64
Description:        

The PostgreSQL 19 pg_dump documentation currently states:
"When --statistics is specified, pg_dump will include most optimizer
statistics in the resulting dump file. This does not include all statistics,
such as those created explicitly with CREATE STATISTICS, custom statistics
added by an extension, or statistics collected by the cumulative statistics
system. Therefore, it may still be useful to run ANALYZE after restoring
from a dump file to ensure optimal performance; see Section 24.1.3 and
Section 24.1.6 for more information."
https://www.postgresql.org/docs/19/app-pgdump.html

However, PostgreSQL 19 introduced support for restoring extended statistics
with pg_restore_extended_stats(), and the following commits appear to add
support for dumping and restoring CREATE STATISTICS data:

・Include extended statistics data in pg_dump
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=c32fb29e9

・Add pg_restore_extended_stats()
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=0e80f3f88

Because of these changes, it appears that statistics created explicitly with
CREATE STATISTICS are now handled by pg_dump --statistics, while the
PostgreSQL 19 documentation still states that they are not included.

Could you please confirm whether the documentation is correct, or whether
this is a documentation bug?

view thread (3+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: BUG #19529: Documentation appears inconsistent with pg_dump --statistics behavior for CREATE STATISTICS objects
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox