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 at scale levels not so different from XFS or EXT4.

Comments

Comments are closed.

Great content and technical takeaways

Great talk! Funny and at the same time very informative.

Argomento e contenuti molto interessanti. Presentazione un po’ troppo dispersiva su dettagli che non si possono seguire bene in questi tipi di evento

Funny and useful talk on pushing forward big use case in postgresql

I like the good old Linux sysadmin stuff!

Good content and technical view, very specific environment!

A short but super practical lesson on how to achieve really powerful performance from PostgreSQL with ZFS. Great speech, thanks!