Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Vindicating ZFS with PostgreSQL: Unleashing the Power of Scalability | POSETTE 2024

Microsoft Developer
588K subscribers
<__slot-el>
<__slot-el>
465 views 10 months ago #PostgreSQL #Database #PosetteConf
Video of a conference talk about vindicating ZFS with PostgreSQL presented by Federico Campoli at POSETTE: An Event for Postgres 2024. In the ever-evolving landscape of database systems, PostgreSQL stands as a robust and highly capable RDBMS. However, achieving optimal performance at scale requires careful consideration of the underlying file system. This presentation will talk about ZOL (ZFS on Linux), a powerful and advanced file system originally developed by Sun Microsystems. ZFS point of strength are robust data storage management, data integrity, data compression, snapshotting, and efficient storage allocation. However ZFS performances are terrible if compared with the native file systems like XFS or EXT4. This presentation will help the attendees to have a better understanding for harnessing the power of ZFS and run PostgreSQL on ZOL at scale levels not so different from XFS or EXT4. Federico is a freelance consultant with long experie …...more
...more
Vindicating ZFS with PostgreSQL: Unleashing the Power of Scalability | POSETTE 2024
25Likes
465Views
Jun 132024
Video of a conference talk about vindicating ZFS with PostgreSQL presented by Federico Campoli at POSETTE: An Event for Postgres 2024. In the ever-evolving landscape of database systems, PostgreSQL stands as a robust and highly capable RDBMS. However, achieving optimal performance at scale requires careful consideration of the underlying file system. This presentation will talk about ZOL (ZFS on Linux), a powerful and advanced file system originally developed by Sun Microsystems. ZFS point of strength are robust data storage management, data integrity, data compression, snapshotting, and efficient storage allocation. However ZFS performances are terrible if compared with the native file systems like XFS or EXT4. This presentation will help the attendees to have a better understanding for harnessing the power of ZFS and run PostgreSQL on ZOL at scale levels not so different from XFS or EXT4. Federico is a freelance consultant with long experience on PostgreSQL. He started his career as Oracle DBA in 2004 and fell in love with PostgreSQL in 2007. Previously he worked as data engineer for Transferwise. After several years spent in the UK he is now back in Italy. He’s an amateur jazz guitarist. Chapters: 00:00 - Intro with jazz music composed by Federico! 04:07 - Start of real-world customer story 06:38 - About Postgres 07:16 - About Linux 09:22 - Gently pushing Postgres & Linux together 12:17 - File systems 13:32 - Enter ZFS 16:57 - Testing and performance 📕 Everything you need to know about POSETTE: An Event for Postgres 2024 can be found at: https://aka.ms/posette ✅ Learn more: Watch more POSETTE talks: https://aka.ms/posette-playlist-2024 📌 Let’s connect: X – @PosetteConf https://x.com/PosetteConf Mastodon - @posetteconf https://mastodon.social/@posetteconf Threads – @posetteconf https://www.threads.net/@posetteconf 🔔 Subscribe to the POSETTE News: https://aka.ms/posette-subscribe 📣 Slides for this talk: https://speakerdeck.com/the4thdoctor/... #PosetteConf #PostgreSQL #Database Presenters: Federico Campoli, Freelance PostgreSQL consultant Connect: Federico Campoli: https://fosstodon.org/@4thdoctor_scarf,   / federicocampoli   📕 Everything you need to know about POSETTE: An Event for Postgres 2024 can be found at: https://aka.ms/posette ✅ Learn more: Watch more POSETTE talks: https://aka.ms/posette-playlist 📌 Let’s connect: X – @PosetteConf https://x.com/PosetteConf Mastodon - @posetteconf https://mastodon.social/@posetteconf Threads – @posetteconf https://www.threads.net/@posetteconf 🔔 Subscribe to the POSETTE News: https://aka.ms/posette-subscribe 📣 Slides for this talk: https://speakerdeck.com/the4thdoctor/... #PosetteConf #PostgreSQL #Database

Follow along using the transcript.

Microsoft Developer

588K subscribers