【Part1】2025年版 トランザクションID関連の問題の傾向と対策 ～ トランザクションIDの概要と可視性判断について ～

This is a video of the presentation "Trends and Solutions for Transaction ID-Related Issues in 2025" given by SRA OSS at the PostgreSQL Conference Japan 2025, held on November 21, 2025, and organized by the Japan PostgreSQL Users Group. Part 1 features a PostgreSQL engineer explaining the overview of transaction IDs and the mechanism for determining visibility. Please see the description for event details and presentation materials. ▶Chapter List (Table of Contents) • 00:00 Opening Image • 00:23 Company Introduction • 01:11 Self-Introduction • 01:59 Table of Contents • 03:15 Prerequisites... Appendicative Architecture • 06:00 About Transaction IDs • 07:46 Transaction IDs • 11:09 Example of Visibility Judgment ① • 12:10 Example of Visibility Judgment ② Continue watching this video here: Understanding the Loop Problem by Actually Generating It:    • 【Part2】2025年版 トランザクションID関連の問題の傾向と対策 ～ 周回問題...   Creating a Multi-Transaction ID:    • 【Part3】2025年版 トランザクションID関連の問題の傾向と対策 ～ マルチト...   ■ Seminar Overview "Trends and Countermeasures for Transaction ID-Related Problems in 2025" While you may not often be aware of transaction ID-related problems, they are serious issues that can lead to service interruptions if they occur. This presentation will provide a basic explanation of the transaction ID wraparound problem, and will also cover multi-transaction IDs, a topic rarely discussed, including recent troubleshooting examples. We will also introduce monitoring techniques necessary to prevent problems and suggest improvements based on the latest development trends. ■ Seminar Materials List https://www.sraoss.co.jp/event_semina... □ "2025 Edition: Trends and Countermeasures for Transaction ID-Related Issues" Presentation Materials https://www.sraoss.co.jp/wp-content/u... ■ SRA OSS https://www.sraoss.co.jp/ ■ Facebook   / sraosskk   ■ SRA OSS Tech Blog https://www.sraoss.co.jp/tech-blog/ #postgresql #postgresqlconferencejapan #transactionID #OSS #dbms #database #data #support #sraoss