Re: Sequence Access Method WIP
Petr Jelinek <petr@2ndquadrant.com>
From: Petr Jelinek <petr@2ndquadrant.com>
To: Heikki Linnakangas <hlinnakangas@vmware.com>,
Simon Riggs <simon@2ndQuadrant.com>
Cc: Andres Freund <andres@2ndquadrant.com>,
PostgreSQL-development <pgsql-hackers@postgresql.org>,
Alvaro Herrera <alvherre@2ndquadrant.com>
Date: 2015-02-15T18:40:24Z
Lists: pgsql-hackers
Attachments
- 0001-seqam-v7.patch (text/x-diff) patch v7-0001
- 0002-seqam-ddl-v3.patch (text/x-diff) patch v3-0002
- 0003-gapless-sequence-v4.patch (text/x-diff) patch v4-0003
Hi, sending new version that is updated along the lines of what we discussed at FOSDEM, which means: - back to single bytea amdata column (no custom columns) - the dump/restore interfaces were changed to produce/accept array of key/value pairs - psql shows the output of dump interface in verbose mode (this makes it easier to inspect the state) - last_value and is_called are always present columns even if the sequence am does not care for them (this helps with backwards compatibility with various admin tools) - pg_dump uses new interface for dumping only for non-local sequences so that dumps of schemas which are not using custom seqams are restorable to older postgres - the default_sequenceam was changed to serial_sequenceam and only applies to serial/bigserial columns - I would personally prefer to have the old default but default for serial is better than nothing - added description of pg_seqam catalog to docs - gapless_seq still uses table internally to support snapshots for pg_dump - pg_dump support for dumping the sequence ams It would be nice to also have something along the lines of chapter 55.2. (Index Access Method Functions), I plan to send that as additional patch in few days. -- Petr Jelinek http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
Commits
-
Add missing gss option to msvc config template
- 3063e7a84026 9.6.0 cited