Anson Abraham has presented the following presentations
PostgreSQL to cloud manage or self-manage?
at
Postgres Conference 2020
Which is better to have self-managed PG or use azure's.,AWS's or GCP's PG database instance?
presented by Anson Abraham
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...
more Case Studies
Omics data and PostgreSQL
at
Postgres Conference 2020
Using PG to store and query Omics data
presented by Anson Abraham
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...
more Case Studies
When to use JSONB and When not to use JSONB in postgres
at
Postgres Conference
Some Use cases as to when you shouldn't use JSONB in postgres.
presented by Anson Abraham
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.
Fri 22 2019 Use Cases