跳转到主要内容
FOLLOW THE EVOLUTION
PostgreSQL 10 目录变更
从一次升级开始，了解目录、字段与类型的变化。
对比任意两个版本，也可以沿着发布历史逐步探索。
比较包含 PostgreSQL 19 beta 3 快照，结果不代表最终发布结构。
PostgreSQL 9.6 → 10
+ attidentity
+ relispartition+ relpartbound
+ collprovider+ collversion
+ line_number+ type+ database+ user_name+ address+ netmask+ auth_method+ options+ error
+ partrelid+ partstrat+ partnatts+ partattrs+ partclass+ partcollation+ partexprs
+ permissive
+ polpermissive
+ oid+ pubname+ pubowner+ puballtables+ pubinsert+ pubupdate+ pubdelete
+ oid+ prpubid+ prrelid
+ pubname+ schemaname+ tablename
+ temporary
+ seqrelid+ seqtypid+ seqstart+ seqincrement+ seqmax+ seqmin+ seqcache+ seqcycle
+ schemaname+ sequencename+ sequenceowner+ data_type+ start_value+ min_value+ max_value+ increment_by+ cycle+ cache_size+ last_value
+ backend_type
+ sent_lsn+ write_lsn+ flush_lsn+ replay_lsn+ write_lag+ flush_lag+ replay_lag− sent_location− write_location− flush_location− replay_location
+ subid+ subname+ pid+ relid+ received_lsn+ last_msg_send_time+ last_msg_receipt_time+ latest_end_lsn+ latest_end_time
+ oid+ stxrelid+ stxname+ stxnamespace+ stxowner+ stxkeys+ stxkind+ stxndistinct+ stxdependencies
+ oid+ subdbid+ subname+ subowner+ subenabled+ subconninfo+ subslotname+ subsynccommit+ subpublications
+ srsubid+ srrelid+ srsubstate+ srsublsn
+ tgoldtable+ tgnewtable