Federico Campoli
Freelance PostgreSQL consultant
Actions
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.
Area of Expertise
Topics
Vindicating ZFS with PostgreSQL: Unleashing the Power of Scalability
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.
Vindicating ZFS with PostgreSQL: Unleashing the Power of Scalability
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.
Protecting your data with Patroni and pgBackRest
Patroni is a solid and reliable HA tool. Pgbackrest is the perfect choice to have a proper DR solution in place. The talk will showhow to configure patroni and pgBackrRest to work together and bootstrap a patroni cluster from a pgBackRest and how to create new replicas using pgBackRest.
The talk will also describe also to perform a disaster recovery using a pgBackrRest repository saved in cloud.
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top