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.

Payal Singh has presented the following presentations

Essential Postgres Performance tuning at Postgres Conference
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 at PGConf Local: Philly 2017 [PgConf.US]

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. at PGConf US 2015 [PgConf.US]

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 at PostgresConf US 2018
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