Payal Singh
Database Reliability Engineer at credativ US
About
Payal has extensive experience working on all aspects of open source databases, primarily Postgres and MySQL. She is a data science enthusiast, and generally loves all things having to do with data.
Essential Postgres Performance tuning
A look at most important postgres and OS parameters to improve performance
presented by Payal Singh
Looking at the list of kernel and postgresql.conf parameters, tuning your PostgreSQL database may seem like a daunting task. While each parameter has a role to play, in most scenarios just a handful of these end up impacting performance the most. This talk aims to be a quick practical guide to tuning your PostgreSQL cluster to get the best possible performance with the least effort, with specia...
more Thu 21 2019 Ops and Administration
Securing Your Data on Postgres
presented by Payal Singh
This talk will cover the various features that Postgres provides for data security, from the very basic to the most advanced.
While most applications are aware of the minimum basic security features and use them, there is often a lack of understanding about how best to manage them, especially with major security features being released with every major version of Postgres. As for advanced f...
more PostgreSQL
Think Your Postgres Backups And Disaster Recovery Are Safe? Let's talk.
presented by Payal Singh
Disaster recovery is perhaps the most ignored aspect of managing PostgreSQL in production systems, and its value is only realized in a moment of crisis. If not done right, absence of backup and recovery strategies can make one repent for days, if not months after. Even when catered to, majority of production systems only have at most one defined backup and recovery strategy, not realizing the b...
more Admin
Securing Your Data on PostgreSQL
Protecting your data at the Database Tier
presented by Payal Singh
This talk will cover the various features that Postgres provides for data security, from the very basic to the most advanced.
While most applications are aware of the minimum basic security features and use them, there is often a lack of understanding about how best to manage them, especially with major security features being released with every major version of Postgres. As for advanced fe...
more Operations and Administration