- Conference - lists.ivorysql.org

New submission: An Introduction to Memory Contexts
by HOW2025 May 15, 2025

May 15, 2025

Chris Travers has submitted a new session! An Introduction to Memory Contexts When writing extensions in C or related languages, how PostgreSQL manages memory is important. This talk will go over how PostgreSQL manages memory, how we select memory management lifecycles, and how we can verify that our extensions are using this system safely. The talk includes key discussions of best practices. Open session [https://sessionize.com/app/organizer/session/19661/932615] These notifications can be turned off on Edit event [https://sessionize.com/app/organizer/event/edit/19661#_tab-advanced] page. Tip: You've used Classic (confer***(a)***orysql.org) to login. You're receiving this message because you had joined event 'HOW2025' on Sessionize. Sessionize.com, PO Box 6945, Unit 34564, London W1A 6US, UK

1 0

New submission: The Future of PostgreSQL in a changing world
by HOW2025 May 15, 2025

May 15, 2025

Chris Travers has submitted a new session! The Future of PostgreSQL in a changing world PostgreSQL, like open source software in general arose in the mid-1990's. This time corresponded during a time when there was a massive effort at building a grand interconnected, highly globalized world. Now, geopolitics is shifting and efforts are made at de-risking and de-globalization. The current trends of de-risking and de-globalization pose both risks and opportunities for projects like PostgreSQL. This talk explores the threats and opportunities for PostgreSQL and other open source projects in this changing world. Open session [https://sessionize.com/app/organizer/session/19661/932614] These notifications can be turned off on Edit event [https://sessionize.com/app/organizer/event/edit/19661#_tab-advanced] page. Tip: You've used Classic (confer***(a)***orysql.org) to login. You're receiving this message because you had joined event 'HOW2025' on Sessionize. Sessionize.com, PO Box 6945, Unit 34564, London W1A 6US, UK

1 0

New submission: Building Petabyte-Scale Postgres Clusters
by HOW2025 May 15, 2025

May 15, 2025

Chris Travers has submitted a new session! Building Petabyte-Scale Postgres Clusters At one of the previous places I have worked, we built a semi-structured data store that stored 10PB of log data for the support team's use. This was done with PostgreSQL and involved less hardware than ElasticSearch at a cost of some functionality. Today I am one of the contributors to an open source successor to that project. This talk will go through the design of the system on a high level, how it works, and how to architect large-scale distributed data platforms using PostgreSQL or other storage technologies. Open session [https://sessionize.com/app/organizer/session/19661/932611] These notifications can be turned off on Edit event [https://sessionize.com/app/organizer/event/edit/19661#_tab-advanced] page. Tip: You've used Classic (confer***(a)***orysql.org) to login. You're receiving this message because you had joined event 'HOW2025' on Sessionize. Sessionize.com, PO Box 6945, Unit 34564, London W1A 6US, UK

1 0

New submission: PostgreSQL 18 and Asynchronous I/O: An Architectural Leap Toward Modern Data Workloads
by HOW2025 May 13, 2025

May 13, 2025

Wagner Bianchi has submitted a new session! PostgreSQL 18 and Asynchronous I/O: An Architectural Leap Toward Modern Data Workloads PostgreSQL 18 introduces the first foundational integration of asynchronous I/O (async I/O) into the ecosystem, marking a historic shift in how PostgreSQL interacts with modern Linux storage subsystems. This paper explains the architectural changes behind adopting io_uring, the modern kernel asynchronous I/O framework introduced in Linux 5.1. We will explore how PostgreSQL now leverages memory-mapped shared ring buffers (Submission Queue and Completion Queue) to minimize syscall overhead, reduce latency, and unlock higher parallelism during disk operations. The paper will also cover how PostgreSQL’s shared buffer architecture complements asynchronous I/O, and will compare PostgreSQL’s conservative gradual adoption strategy to other RDBMS engines such as MySQL/InnoDB and Oracle Database. Practical examples, early benchmarking scenarios, and operational tuning recommendations for PostgreSQL 18 on XFS with io_uring will be presented. This hands-on, system-oriented guide will help engineers, DBAs, and cloud architects understand what to expect from asynchronous I/O in PostgreSQL and how to prepare for its maturation in PostgreSQL 19 and beyond. Open session [https://sessionize.com/app/organizer/session/19661/931230] These notifications can be turned off on Edit event [https://sessionize.com/app/organizer/event/edit/19661#_tab-advanced] page. Tip: You've used Classic (confer***(a)***orysql.org) to login. You're receiving this message because you had joined event 'HOW2025' on Sessionize. Sessionize.com, PO Box 6945, Unit 34564, London W1A 6US, UK

1 0

New submission: YDB: extending a Distributed SQL DBMS with PostgreSQL compatibility
by HOW2025 May 12, 2025

May 12, 2025

Ivan Blinkov has submitted a new session! YDB: extending a Distributed SQL DBMS with PostgreSQL compatibility PostgreSQL is an implementation of the SQL standard with one of the most vibrant ecosystems around it. To leverage all the tools and libraries that already know how to work with PostgreSQL, emerging database management systems that bring something new to the market need to learn how to mimic PostgreSQL. This talk explores possible approaches to this and related trade-offs, as well as reasoning why YDB chose a unique approach to bring serializable consistency and seamless scalability to the PostgreSQL ecosystem. Open session [https://sessionize.com/app/organizer/session/19661/929813] These notifications can be turned off on Edit event [https://sessionize.com/app/organizer/event/edit/19661#_tab-advanced] page. Tip: You've used Classic (confer***(a)***orysql.org) to login. You're receiving this message because you had joined event 'HOW2025' on Sessionize. Sessionize.com, PO Box 6945, Unit 34564, London W1A 6US, UK

1 0

New submission: Open Source At A Crossroads
by HOW2025 May 6, 2025

May 6, 2025

Michael Meskes has submitted a new session! Open Source At A Crossroads For the first time in history almost everyone uses Open Source, albeit often without getting the benefits of Free Software. Open Source has accomplished unparalleled success in the IT industry, but with success comes challenges and risks. Over recent decades we have seen business models change while the industry and the users found the best ways to use Open Source. With Software as a Service we now see a fairly new but very successful approach, that goes hand in hand with Open Source, but is not without issues. This presentation will walk the audience through different approaches of monetizing and developing Open Source and examine the consequences of SaaS models for the Open Source ecosystem. Open session [https://sessionize.com/app/organizer/session/19661/926411] These notifications can be turned off on Edit event [https://sessionize.com/app/organizer/event/edit/19661#_tab-advanced] page. Tip: You've used Classic (confer***(a)***orysql.org) to login. You're receiving this message because you had joined event 'HOW2025' on Sessionize. Sessionize.com, PO Box 6945, Unit 34564, London W1A 6US, UK

1 0

New submission: Open Source In The Age Of Cloud And Microservices
by HOW2025 May 6, 2025

May 6, 2025

Michael Meskes has submitted a new session! Open Source In The Age Of Cloud And Microservices The movement to cloud and microservice architectures have changed the industry quite a bit recently. These changes have an influence on open source both from a community and from a business perspective. This presentation takes you on a journey of 30+ years of free and open-source software development. It shows the evolution of the movement and the ecosystem. With changes in business models open source communities have changed and vice versa. The requirements of cloud and microservices have forced yet another paradigm shift onto the open source world. However, the more things change, the more they stay the same. Thus this presentation also shows how resilient the open source movement is. Open session [https://sessionize.com/app/organizer/session/19661/926410] These notifications can be turned off on Edit event [https://sessionize.com/app/organizer/event/edit/19661#_tab-advanced] page. Tip: You've used Classic (confer***(a)***orysql.org) to login. You're receiving this message because you had joined event 'HOW2025' on Sessionize. Sessionize.com, PO Box 6945, Unit 34564, London W1A 6US, UK

1 0