Horton

Unlogged sequences

Peter Eisentraut <peter@eisentraut.org>

View on postgr.es
Commit: 344d62fb9a978a72cf8347f0369b9ee643fd0b31
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2022-04-07T14:18:00Z
Releases: 15.0 
Unlogged sequences

Add support for unlogged sequences.  Unlike for unlogged tables, this
is not a performance feature.  It allows sequences associated with
unlogged tables to be excluded from replication.

A new subcommand ALTER SEQUENCE ... SET LOGGED/UNLOGGED is added.

An identity/serial sequence now automatically gets and follows the
persistence level (logged/unlogged) of its owning table.  (The
sequences owned by temporary tables were already temporary through the
separate mechanism in RangeVarAdjustRelationPersistence().)  But you
can still change the persistence of an owned sequence separately.
Also, pg_dump and pg_upgrade preserve the persistence of existing
sequences.

Discussion: https://www.postgresql.org/message-id/flat/04e12818-2f98-257c-b926-2845d74ed04f%402ndquadrant.com

Files

PathChange+/−
doc/src/sgml/ref/alter_sequence.sgml modified +12 −0
doc/src/sgml/ref/alter_table.sgml modified +6 −0
doc/src/sgml/ref/create_sequence.sgml modified +22 −1
doc/src/sgml/ref/create_table.sgml modified +5 −0
doc/src/sgml/ref/pg_dump.sgml modified +4 −3
src/backend/commands/sequence.c modified +50 −8
src/backend/commands/tablecmds.c modified +29 −3
src/backend/parser/parse_utilcmd.c modified +1 −0
src/bin/pg_dump/pg_dump.c modified +13 −2
src/bin/psql/describe.c modified +6 −2
src/bin/psql/tab-complete.c modified +4 −1
src/include/commands/sequence.h modified +1 −0
src/test/recovery/t/014_unlogged_reinit.pl modified +55 −6
src/test/regress/expected/alter_table.out modified +2 −2
src/test/regress/expected/sequence.out modified +18 −2
src/test/regress/sql/sequence.sql modified +9 −1

Documentation touched

Discussion