提高Postgres连接可伸缩性：快照

%3CLINGO-SUB%20id%3D%22lingo-sub-1806462%22%20slang%3D%22en-US%22%3EImproving%20Postgres%20Connection%20Scalability%3A%20Snapshots%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1806462%22%20slang%3D%22en-US%22%3E%3CP%3EI%20recently%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fazure-database-for-postgresql%2Fanalyzing-the-limits-of-connection。-scalability-in-postgres%2Fba-p%2F1757266%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3Eanalyzed%20the%20limits%20of%20connection%20scalability%3C%2FA%3E%2C%20to%20understand%20the%20most%20effective%20way%20to%20improve%20Postgres'；%20handling%20of%20large%20numbers%20of%20connections%2C%20and%20why%20that%20is%20important.%20I%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fazure-database-for-postgresql%2Fanalyzing-the-limits-of-connection-scalability-in-postgres%2Fba-p%2F1757266%23conclusion-start-by-improving-snapshot-scalability-in-postgres%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3Econcluded%3C%。2FA%3E%20that%20the%20most%20pressing%20issue%20is%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fazure-database-for-postgresql%2Fanalyzing-the-limits-of-connection-scalability-in-postgres%2Fba-p%2F1757266%23snapshot-scalability%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3Esnapshot%20scalability%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C。%2FP%3E%0A%3CP%3EThis%20post%20details%20the%20improvements%20I%20recently%20contributed%20to%20Postgres%2014%20(to%20be%20released%20Q3%20of%202021)%2C%20significantly%20reducing%20the%20identified%20snapshot%20scalability%20bottleneck.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22pgbench-before-and-after-performance-comparison-Postgres。-snapshot-scalability-v2-1920x1080.jpg%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F228383i00393979FBE65C85%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22pgbench-before-and-after-performance-comparison-Postgres-snapshot-scalability-v2-1920x1080.jpg%22%20alt%3D。%22pgbench-before-and-after-performance-comparison-Postgres-snapshot-scalability-v2-1920x1080.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EAs%20the%20explanation%20of%20the%20implementation%20details%20is%20fairly%20long%2C%20I%20thought%20it%E2%80%99d%20be%20more%20fun%20for%20of%20you%20if%20I%20start%20with%20the%20results%20of%20the%20work%2C%20instead%20of%20the。%20technical%20details%20(I%E2%80%99m%20cheating%2C%20I%20know%20%3B)).%3C%2FP%3E%0A%3CHR%20%2F%3E%0A%3CDIV%20class%3D%22toc%22%3E%3CNAV%20id%3D%22TableOfContents%22%3E%0A%3COL%3E%0A%3CLI%3E%3CA%20href%3D%22%23first-performance-improvements%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%。20noopener%20noreferrer%22%3EFirst%3A%20Performance%20Improvements%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22%23unfortunately-a-minimal-transaction-visibility-primer%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EUnfortunately%3A%20A%20Minimal%20Transaction%20Visibility%20Primer%3C%2FA%3E%3COL%3E%0A%3CLI%3E%3CA%20href%3D%22%23multi-。Version-concurrency-control-mvcc%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMulti%20Version%20Concurrency%20Control%20(MVCC)%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22%23snapshots%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESnapshots%3F%3C%2FA%3E%3C%2FLI%3E。%0A%3CLI%3E%3CA%20href%3D%22%23snapping-snapshots%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESnapping%20Snapshots%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22%23past-optimizations%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EPast%20Optimizations%3C%2FA%3E%3C。%2FLI%3E%0A%3C%2FOL%3E%0A%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22%23finally-addressing-bottlenecks%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EFinally%3A%20Addressing%20Bottlenecks%3C%2FA%3E%3COL%3E%0A%3CLI%3E%3CA%20href%3D%22%23bottleneck-1-ping-pong%22%20target%3D%22_self%22。%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EBottleneck%201%3A%20Ping%20Pong%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22%23interlude-removing-the-need-for-recentglobalxminhorizon%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EInterlude%3A%20Removing%20the%20need%20for%3CCODE%3ERecentGlobalXminHorizon%3C%2FCODE%3E%3C%2FA%3E。%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22%23bottleneck-2-density%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EBottleneck%202%3A%20Density%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22%23bot