preserving statistics settings

From: nconway(at)klamath(dot)dyndns(dot)org (Neil Conway)
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: preserving statistics settings
Date: 2002-07-19 16:27:10
Message-ID: 20020719162710.GA21879@klamath.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Shouldn't the effect of ALTER TABLE ALTER COLUMN SET STATISTICS be
recorded by pg_dump?

For example:

CREATE TABLE foo (col1 int, col2 int);

ALTER TABLE foo ALTER COLUMN col1 SET STATISTICS 100;

$ pg_dumpall

After removing the database and restoring from the dump, the effect of
the ALTER TABLE ALTER COLUMN SET STATISTICS will be lost...

Cheers,

Neil

--
Neil Conway <neilconway(at)rogers(dot)com>
PGP Key ID: DB3C29FC

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-07-19 16:39:16 Re: preserving statistics settings
Previous Message Josh Berkus 2002-07-19 15:26:37 Adventures in PostgreSQL