Replace ALTER TABLE ... SET STATISTICS DISTINCT with a more general mechanism.
Robert Haas <rhaas@postgresql.org>
Replace ALTER TABLE ... SET STATISTICS DISTINCT with a more general mechanism. Attributes can now have options, just as relations and tablespaces do, and the reloptions code is used to parse, validate, and store them. For simplicity and because these options are not performance critical, we store them in a separate cache rather than the main relcache. Thanks to Alex Hunsaker for the review.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/catalogs.sgml | modified | +10 −14 |
| doc/src/sgml/ref/alter_table.sgml | modified | +16 −8 |
| doc/src/sgml/ref/analyze.sgml | modified | +2 −2 |
| src/backend/access/common/reloptions.c | modified | +49 −1 |
| src/backend/access/common/tupdesc.c | modified | +3 −6 |
| src/backend/bootstrap/bootstrap.c | modified | +1 −2 |
| src/backend/catalog/genbki.pl | modified | +10 −5 |
| src/backend/catalog/heap.c | modified | +25 −21 |
| src/backend/catalog/index.c | modified | +1 −2 |
| src/backend/commands/analyze.c | modified | +27 −7 |
| src/backend/commands/tablecmds.c | modified | +47 −73 |
| src/backend/parser/gram.y | modified | +14 −5 |
| src/backend/utils/cache/Makefile | modified | +2 −2 |
| src/bin/pg_dump/pg_dump.c | modified | +31 −34 |
| src/bin/pg_dump/pg_dump.h | modified | +2 −2 |
| src/bin/psql/tab-complete.c | modified | +1 −12 |
| src/include/access/reloptions.h | modified | +4 −2 |
| src/include/catalog/pg_attribute.h | modified | +19 −23 |
| src/include/nodes/parsenodes.h | modified | +3 −2 |