JSON and analytics in Postgres using index and columnar.
Presented by:
Gleb Otochkin
Gleb is a Cloud Advocate at Google who specializes in Cloud Database technologies in the Google Cloud. He has over 20 years of experience in data-related technologies, and has expertise in a variety of areas, including relational databases, Big Data, application development, data replication and integration solutions, including products from Google, Oracle, AWS, Cloudera, and other vendors. He has been honored to be a presenter at various conferences in the USA, Europe, and APAC.
No video of the event yet, sorry!
We want it to be fast, reliable and flexible. We want JSON and we want OLTP with ACID. Can all it work together or we need to choose 2 out of three of our wishes again? What technology can help to speed up the JSON queries? A couple of different approaches for JSON data analytics. Here is what we are going to discuss: - JSON data types - usage and challenges - Indexes for JSON data types - Columnar store and how it works with JSON - What do we want in the future
- Date:
- 2024 April 18 10:00 PDT
- Duration:
- 50 min
- Room:
- Winchester
- Conference:
- Postgres Conference 2024
- Language:
- English
- Track:
- Dev
- Difficulty:
- Easy