Payal Singh
Database Reliability Engineer at credativ US
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.
Upcoming presentations
No upcoming presentations...
Past presentations
Essential Postgres Performance tuning
A look at most important postgres and OS parameters to improve performance
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...
Mar 21 2019
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...
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...
Securing Your Data on PostgreSQL
Protecting your data at the Database Tier
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...