Peter Celentano
Specialist Solutions Architect (PostgreSQL) at AWS - Solutions Architect
Peter Celentano is a Senor Specialist Solutions Architect, specalizing in RDS PostgreSQL and Aurora PostgreSQL. He works with AWS customers to design scalable, secure, performant, and robust database architectures on the cloud.
Upcoming presentations
No upcoming presentations...
Past presentations
PostgreSQL architecture considerations for application developers
Why should developers care about PostgreSQL internals?
Although the application layer is the portion the world accesses for many cloud architectures, it seems that we rarely consider how we can optimize our application for the database we’re using. When using any relational database engine, it’s important to consider not just schema design, but understanding how databases read and write data to their storage systems to ensure the application is man...
Apr 18 2024
Scheduled PostgreSQL jobs with AWS Batch
Re-inventing the wheel with the cloud in mind
Since before PostgreSQL existed, CRON has been the standard daemon for scheduling nearly any task in the Linux ecosystem. With the rise of cloud computing and managed database instances, job scheduling has gotten slightly more complicated then running a simple PSQL script on our database server, and connecting through a Unix socket. While the simplest methods of running scheduled database job...
Bi-directional replication with PGlogical
basic setup, monitoring, and lessons learned
In the PostgreSQL ecosystem, we've been waiting for true bi-directonal replication for some time. While we've been promised this feature for some time, it's still not available in PostgreSQL core. There are several solutions that can provide us with this much sought-after feature, but the one we'll be talking about today is PGlogical.
PGlogical is better know in the community as one of t...
Monitoring PostgreSQL with Grafana and TimescaleDB
Make monitoring great again!
Regardless of where they're hosted, knowing what your database is doing at all times is a necessary component in a solid infrastructure. Grafana and TimescaldDB form the foundation of a monitoring stack which can be built and scaled to monitor nearly any production environment. While solutions such as Zabbix and Nagios allow for similar solutions, they are often cumbersome to navigate, need con...
Mar 20 2019