Anson Abraham
Sr. Data Architect at N/A
Upcoming presentations
No upcoming presentations...
Past presentations
PostgreSQL to cloud manage or self-manage?
Which is better to have self-managed PG or use azure's.,AWS's or GCP's PG database instance?
Azure,GCP, AWS are the big 3 cloud platforms. Each provide PostgreSQL as a service in their cloud services. Are there benefits to using the clouds PG managed instance or is it better to spin up VMs/EC2 instances and install PostgreSQL and then manage on your own? Some say that it's always better to spin up EC2/VM instances. But some could argue it's better to use the managed instances. I wil...
Omics data and PostgreSQL
Using PG to store and query Omics data
Advances in the technologies and informatics used to generate and process large biological data sets (omics data) are promoting a critical shift in the study of biomedical sciences. While genomics, transcriptomics and proteinomics, coupled with bioinformatics and biostatistics, are gaining momentum, they generate tera- to peta-byte sized data files on a daily basis. These data file sizes, toge...
When to use JSONB and When not to use JSONB in postgres
Some Use cases as to when you shouldn't use JSONB in postgres.
Use case of using JSONB in PG, when it works and when it doesn't work, and you'll need to work another doc store and use FDW to access from PG.
Mar 22 2019