Program for PGConf India, 2024

2024-02-28
08:00
PGConf Organizers

Conference Registration on Training Day
Conference Registration on Training Day

presented by PGConf Organizers from PGConf India

Conference Registration

08:00 - 09:00 Grand Victoria Other
09:00
HariKrishna

Maintaining your PostgreSQL DB healthy and resilient

presented by HariKrishna from AWS

Ever increasing data volumes and/or traffic put stress on Customer’s databases and leads to performance bottle-necks affecting user experience and increase business risk due to degrading availability and performance. This training will focus on tips/tricks on finding/resolving of PostgreSQL database health issues in the below 5 key areas. The training session will be a mix of theory and hands ...

more

09:00 - 12:30 Grand Victoria A Training
Luigi Nardi

Mastering PostgreSQL parameter tuning: A practical approach

presented by Luigi Nardi from DBtune

This training session will consist of 2 parts. The first is a short presentation that introduces the concept and the basics of database parameter tuning, why it’s so important and the business value that can be realized when systems and applications are optimally tuned. We will explore existing options for addressing this critical task, including manual tuning and existing open-source solutions...

more

09:00 - 12:30 Grand Victoria B Training
Alicja Kucharczyk Aditya D

Building AI Applications with Azure OpenAI and PostgreSQL

presented by Alicja Kucharczyk, Aditya D from Microsoft

Join us for an immersive training session that will equip you with the essential skills to integrate Azure Database for PostgreSQL - Flexible Server with Azure OpenAI for building advanced AI applications. In this hands-on lab, you will gain practical experience in provisioning, configuring, and harnessing the power of Azure's flexible PostgreSQL service to create cutting-edge AI applications. ...

more

09:00 - 12:30 Robusta Training
Bruce Momjian

Postgres for All Your Data
Postgres for All Your Data

presented by Bruce Momjian from EnterpriseDB

Three capabilities that make Postgres ideal for today's workloads: extensibility, non-relational data handling, and specialized indexing. This training covers them all.

First, it covers the extensibility built into Postgres from its inception. It also covers data analytics and foreign data wrappers which are part of that. Second, it covers the ability to...

more

09:00 - 12:30 Arabica Training
13:00
PGConf Organizers

Training Day Lunch
Training Day Lunch

presented by PGConf Organizers from PGConf India

Training Day Lunch

13:00 - 13:55 Grand Victoria Other
14:00
Bhargav kamineni Sagar Jadhav

PostgreSQL Upgrades
PostgreSQL Upgrades

presented by Bhargav kamineni, Sagar Jadhav from Percona

Postgres Minor version and Major version upgrade strategies

  • Why need to upgrade?
  • Upgrade types - Minor and major version upgrades
  • About Minor version upgrade
  • About Major version upgrade
  • Different ways of major version upgrades
  • Postgres upgrade using pg_dumpall
  • Postgres upgrade using pg_dump
  • Postgres upgrade using pg_upgrade
  • upgrade on RDS
  • Postgres upgrade using l...
more

14:00 - 17:30 Grand Victoria B Training
Abhijeet Rajurkar

Unraveling GEN AI and PG Vector in PostgreSQL
Unraveling GEN AI and PG Vector in PostgreSQL

presented by Abhijeet Rajurkar from Google

In this training we will do a deep dive into implementation of PG Vector and its capabilities.

14:00 - 17:30 Grand Victoria A Training
Franck Pachot

Distributed SQL on containers: YugabyteDB hands-on lab
Distributed SQL on containers: YugabyteDB hands-on lab

presented by Franck Pachot from Yugabyte

Join us for a hands-on lab where we'll dive into Distributed SQL databases, focusing on YugabyteDB—an open-source and PostgreSQL-compatible solution. In this workshop, you'll have the opportunity to install YugabyteDB and test its key features, such as elasticity and resilience. We'll simulate scenarios like adding new containers and failures while running the SQL application.

Throughout the...

more

14:00 - 17:30 Robusta Training
Dinesh Kumar Chemuduru RK Rakesh

PostgreSQL Extensions
PostgreSQL Extensions

presented by Dinesh Kumar Chemuduru, RK Rakesh from Tessell

This training will cover some of the most popular PostgreSQL extensions, their use cases and a deep dive into their usage.

  1. Gain a comprehensive understanding of PostgreSQL extensions and their role in expanding database functionalities.

  2. Explore major extensions, emphasizing PostGIS, pg_routing, hstore, uuid-ossp, pg_trgm, pg_stat_statements, pg_vector, pgbigm, and TimescaleDB.

3....

more

14:00 - 17:30 Arabica Training
2024-02-29
08:00
PGConf Organizers

Conference Registration on Day 1
Conference Registration on Day 1

presented by PGConf Organizers from PGConf India

Conference Registration on Day 1

08:00 - 09:00 Grand Victoria Other
09:00
PGConf Organizers

Opening Remarks
Opening Remarks

presented by PGConf Organizers from PGConf India

Welcome Note

09:00 - 09:15 Grand Victoria Other
09:15
Denis Lussier

Postgres Challenges, Commercial & Community; Past, Present & Future
Postgres Challenges, Commercial & Community; Past, Present & Future

presented by Denis Lussier from pgEdge

In this keynote, I'll delve into the world of PostgreSQL, exploring the challenges it faced in its early stages, the synergy between businesses and communities, and the journey from its origins to what lies ahead. The initial challenges encountered by the PostgreSQL Global Development Group weren't stumbling blocks but rather opportunities to enhance PostgreSQL.

Moving forward, I'll examine ...

more

09:15 - 10:00 Grand Victoria Keynote
10:00
Charles Feddersen

All the Postgres Things at Microsoft
All the Postgres Things at Microsoft

presented by Charles Feddersen from Microsoft

Microsoft is investing a lot in Postgres—including in the Postgres core, Citus open source, Patroni, PgBouncer, pgcopydb, pg_cron, & more Postgres extensions. And Microsoft offers two Azure managed services for PostgreSQL, one is regular and one is distributed Postgres built on Citus. In this talk, you’ll get an overview of some of the interesting Microsoft work on Postgres in the last 12 month...

more

10:00 - 10:20 Grand Victoria Sponsor Keynote
10:20
PGConf Organizers

Tea Break
Tea Break

presented by PGConf Organizers from PGConf India

Day 1 Morning Tea Break

10:20 - 10:50 Grand Victoria Other
10:50
Franck Pachot

A PostgreSQL fork for horizontal scalability: YugabyteDB
architecture and use-cases

presented by Franck Pachot from Yugabyte

YugabyteDB is a PostgreSQL fork that has been enhanced to scale horizontally using a Spanner-like storage and transaction architecture. We will highlight the strengths of YugabyteDB - high availability and elasticity. Additionally, we will compare and contrast YugabyteDB with PostgreSQL, and investigate where the distributed storage fits into the code. Our emphasis will be on analyzing the arch...

more

10:50 - 11:30 Robusta + Arabica Database Engine Developers
Karan Thapar Sibu Behera

Seamlessly monitor and troubleshoot your database performance problems with Query Insights for PostgreSQL
Seamlessly monitor and troubleshoot your database performance problems with Query Insights for PostgreSQL

presented by Karan Thapar, Sibu Behera from Google

Enhanced Query Insights empowers DBAs, developers, and IT generalists to detect and troubleshoot database performance problems with ease. With enhanced Query Insights, our users can view richer and near real-time query telemetry and perform ad-hoc analysis to root-cause and solve complex performance issues. Additionally, enhanced Query Insights surfaces intelligent, ready-to-apply recommendat...

more

10:50 - 11:30 Grand Victoria B Database Administration
Robert Haas

Incremental Backup for PG17
Incremental Backup for PG17

presented by Robert Haas from EnterpriseDB

This talk will be a deep dive into the new incremental backup feature which has been committed for (hopefully) inclusion in PostgreSQL 17.

First, I'll explain how the feature works from a user perspective, and briefly discuss some possible use cases.

Second, I'll discuss the architecture of the feature, both how it actually works and alternative designs which I considered and ultimate...

more

10:50 - 11:30 Grand Victoria A Database Engine Developers
11:35
Floor Drees

Finding PostgreSQL’s fit in the AI space
Finding PostgreSQL’s fit in the AI space

presented by Floor Drees from Aiven

PostgreSQL may not be the first thing that comes to mind when we think about AI, but it's becoming increasingly important for a growing number of users. In this talk, we'll take a look at the current state of AI and explain why PostgreSQL has a potential to play a key role in it. We'll start by exploring workflows and architectures, from the traditional Machine Learning approach of training an...

more

11:35 - 12:15 Grand Victoria A Application Developer
Alexander Kukushkin

pg_upgrade like a boss!

presented by Alexander Kukushkin from Microsoft

Upgrading a database cluster can be a complex and time-consuming process. While there are several methods for upgrade, such as dump/restore and logical replication, pg_upgrade is a powerful tool that allows users to upgrade a cluster with acceptable and predictable downtime.

In this talk, I will explore the benefits of using pg_upgrade for major upgrades, particularly in large, high-availabi...

more

11:35 - 12:15 Grand Victoria B Database Administration
Tushar Amrit

Incremental Materialized Views 101

presented by Tushar Amrit from Bloomberg

THE FASTEST DATABASE QUERY WAS THE ONE THAT WASN’T EXECUTED

Nobody can have control over the ever-expanding datasets and increasingly complex queries at any organization. The role of materialized views in database management for solving these scenarios is paramount. This proposed session, "Incremental Materialized Views 101" aims to equip PostgreSQL enthusiasts with a deep understanding o...

more

11:35 - 12:15 Robusta + Arabica Case Study
12:20
Jelte Fennema-Nio

Postgres load balancing is secretly broken: The cancellation problem

presented by Jelte Fennema-Nio from Microsoft

On certain workloads a single Postgres server cannot deliver the desired performance. If the traffic is read heavy, you could already resolve this by adding read replicas. If the traffic is write heavy then the Citus comes to the rescue.

In both cases the queries of your application need to be sent to a randomly chosen Postgres server, to make these servers share the load. A TCP load balance...

more

12:20 - 13:00 Grand Victoria B Database Administration
Timofey Kulin

YDB — Adding PostgreSQL compatibility to a Distributed SQL database

presented by Timofey Kulin from YDB

YDB is a strongly consistent distributed database for mission-critical workloads with more than a decade of history that has been published to open-source in 2022. It was built from scratch with its own SQL dialect, API and query execution layer. We are happy to present the Postgres compatibility mode that has been added recently in response to open-source user feedback.

A few words ab...

more

12:20 - 13:00 Robusta + Arabica Database Engine Developers
Sachin Khanna Jitender Kumar

Unlocking the Power of Vector Similarity Search with pgvector

presented by Sachin Khanna, Jitender Kumar from AWS

With the rise of generative AI, vector embeddings have become the key to enabling powerful applications like large language models. However, storing and searching vector data is not feasible option for traditional databases.

In this presentation, we will explore pgvector - a PostgreSQL extension that enables efficient storage and retrieval of vector data. We will cover:

  • What are vector...
more

12:20 - 13:00 Grand Victoria A Application Developer
13:05
PGConf Organizers

Day 1 Lunch
Day 1 Lunch

presented by PGConf Organizers from PGConf India

Lunch on Day 1

13:05 - 14:00 Grand Victoria Other
14:00
Rakesh Sharma  Shwetha C Ravoor

An Introduction to PostGIS, H3 and its Integration with Greenplum

presented by Rakesh Sharma, Shwetha C Ravoor from vmware inc.

Greenplum Database is a massively parallel processing (MPP) database server with an architecture specially designed to manage large-scale analytic data warehouses and business intelligence workloads. MPP (a shared-nothing architecture) refers to systems with two or more processors that cooperate to carry out an operation, each with its own memory, operating system, and disks. Greenplum uses ...

more

14:00 - 14:40 Robusta + Arabica Application Developer
Nishchay Kothari

Why Your Security Best Practices Don’t Work

presented by Nishchay Kothari from Fujitsu

Why Your Security Best Practices Don’t Work

Data breaches damage a company's reputation, destroy customer confidence, and can have major financial and legal implications. But you’re ahead of the game, and have adopted new PostgreSQL solution with built-in security offerings.

Naturally, your next step is to download the obligatory Security Best Practice document from your new vendors webs...

more

14:00 - 14:40 Grand Victoria A Database Administration
Ashutosh Bapat

Postgres for analytics

presented by Ashutosh Bapat from EnterpriseDB

PostgreSQL is first and foremost an OLTP DBMS. But it has a rich set of features which allows it to be used as an OLAP DBMS.

  • Highly compliant with SQL standard
  • Analytical features like windowing.
  • Many data types important for analytical workload e.g. JSON, Geo-spatial datatypes
  • Full-text search on document data types
  • Non-traditional indexes like GIN, BRIN
  • Partial and expr...
more

14:00 - 14:40 Grand Victoria B Application Developer
14:45
Nikita Malakhov

Roasted Toasted Json

presented by Nikita Malakhov from Postgres Professional

PostgreSQL is the first relational database recognized the need of non-atomic data types in application development from science to Web. Jsonb in Postgres is the attractive feature for modern application wanted by developers as Json documents with a strong consistency and all the benefits of proven relational technology. At last SQL world has recognized the NoSQL and in 2016 released the new ...

more

14:45 - 15:25 Grand Victoria B Database Engine Developers
Shalaka Dengale Ramya Bhat

PostgreSQL Unboxed: Leveraging Containerization for Scalable Database Deployments

presented by Shalaka Dengale, Ramya Bhat from AWS

In the evolving landscape of modern software deployment, containerization has emerged as a game-changer. This presentation delves into the realm of PostgreSQL deployment through containerization, exploring innovative strategies and best practices to harness the power of containers for managing PostgreSQL databases efficiently. We'll navigate the core concepts of containerization, highlighting ...

more

14:45 - 15:25 Robusta + Arabica Database Administration
Rohan Kumar

Postgres Monitoring: A Practical Peek Under the Hood

presented by Rohan Kumar from

Abstract:

In this session, we will touch on the importance of PostgreSQL monitoring, even when you are using managed offerings like RDS, CloudSQL, etc. I will then delve into how we can leverage open-source tools like postgres_exporter, Prometheus, and Grafana to effectively monitor PostgreSQL.

We will explore the key metrics and performance indicators to track in order to ensure opti...

more

14:45 - 15:25 Grand Victoria A Database Administration
15:30
Justin George

How to Unleash the Power of PostgreSQL in the Cloud
How to Unleash the Power of PostgreSQL in the Cloud

presented by Justin George from Instaclustr by NetApp

PostgreSQL is a widely used database for high performance applications on premises. Migrating these applications to the cloud means you need to consider your cloud infrastructure options to deliver the highest performance available for PostgreSQL.

  • What options are available?
  • How can we scale performance?
  • How far can we push the cloud to meet our database performance needs?

In th...

more

15:30 - 16:10 Grand Victoria B Database Administration
Asim Rama Praveen Sameer Mannava

Using PostgreSQL and PostGIS for climate resilent agriculture

presented by Asim Rama Praveen, Sameer Mannava from IIT Bombay

At IIT Bombay, we are working with the Maharashtra Department of Agriculture on building climate resilience in agriculture of rural Maharashtra. A crucial input for agriculture is rainfall. We've built a model to compute distribution of rainfall into various components such as crop water uptake, soil moisture, groundwater recharge and surface runoff. Using PostgreSQL and PostGIS, we are able...

more

15:30 - 16:10 Robusta + Arabica Case Study
Luigi Nardi

PostgreSQL parameter performance optimization: From manual tuning to autotuning

presented by Luigi Nardi from DBtune

Explore the intricate world of PostgreSQL parameter tuning, where the database management system reveals a myriad of configurable parameters shaping its runtime behavior. With the evolution of the system, numerous parameters came to light — Correctly configuring these parameters is pivotal for enhancing application performance and optimizing cloud resources. The complexity of the parameter inte...

more

15:30 - 16:10 Grand Victoria A Application Developer
16:15
PGConf Organizers

Tea Break
Tea Break

presented by PGConf Organizers from PGConf India

30 minutes Tea Break

16:15 - 16:35 Grand Victoria Other
16:40
PGConf Organizers

Platinum Sponsor Keynote by EnterpriseDB
Platinum Sponsor Keynote by EnterpriseDB

presented by PGConf Organizers from PGConf India

Platinum Sponsor Keynote by EnterpriseDB

16:40 - 16:50 Grand Victoria Sponsor Keynote
16:50
PGConf Organizers

Platinum Sponsor Keynote by Tessell
Platinum Sponsor Keynote by Tessell

presented by PGConf Organizers from PGConf India

Platinum Sponsor Keynote by Tessell

16:50 - 17:00 Grand Victoria Sponsor Keynote
17:00
PGConf Organizers

Lightning Talks and Group Photo
Lightning Talks

presented by PGConf Organizers from PGConf India

Lightning Talks

17:00 - 18:00 Grand Victoria Other
19:00
PGConf Organizers

Conference Dinner @ Long Boat Brewing Company
Conference Dinner

presented by PGConf Organizers from PGConf India

Conference Dinner on Day 1 at Long Boat Brewing Company, 1st Main, MSR Layout, Chandra Layout, Marathahalli, Bengaluru, Karnataka 560037

19:00 - 22:00 Long Boat Brewing Company Other
2024-03-01
08:00
PGConf Organizers

Networking Over Breakfast
Networking Over Breakfast

presented by PGConf Organizers from PGConf India

Networking Over Breakfast

08:00 - 09:00 Grand Victoria Other
09:00
PGConf Organizers

Round Table Discussion
Round Table Discussion

presented by PGConf Organizers from PGConf India

A Round Table Discussion about how we can set up PostgreSQL to succeed in the near and distant future.

09:00 - 09:45 Grand Victoria Other
09:50
Subhash Guddad

AI everywhere with Google Cloud Databases
AI everywhere with Google Cloud Databases

presented by Subhash Guddad from Google

This sponsor keynote will focus on how Google Cloud is integrating AI in all of its database offerings including focus on PostgreSQL.

09:50 - 10:10 Grand Victoria Sponsor Keynote
10:10
PGConf Organizers

Diamond Sponsor Keynote by AWS
Diamond Sponsor Keynote by AWS

presented by PGConf Organizers from PGConf India

Diamond Sponsor Keynote by AWS

10:10 - 10:30 Grand Victoria Sponsor Keynote
10:30
PGConf Organizers

Tea Break
Tea Break

presented by PGConf Organizers from PGConf India

Tea Break in the morning on Day 2

10:30 - 10:50 Grand Victoria Other
10:50
Jim Mlodgenski

Writing fast trusted stored functions in PL/Rust

presented by Jim Mlodgenski from Amazon Web Services

One of PostgreSQL's superpowers is its ability for users to write stored procedures and functions in many different languages like plpglsql, Python, Javascript. They are all powerful in their own way, but they all are interpreted languages which comes with some performance implications. For performance sensitive functions the typical method is to write them in C, but that is not always accessib...

more

10:50 - 11:30 Grand Victoria A Application Developer
Ujjwal Gupta

Use Connection Pooling to Enable Postgres Proxy and to Improve Database Performance

presented by Ujjwal Gupta from SquadStack

Use Connection Pooling to Enable Postgres Proxy and to Improve Database Performance

About:

  1. How we can use connection pooling to enable Postgres proxy?
  2. How we can use connection pooling to improve database performance?

Abstract:

We currently have a cross-region read-replica in place to handle disaster recovery and high availability. So, to connect Postgres clients securely...

more

10:50 - 11:30 Grand Victoria B Case Study
Pushkar Khadilkar	VaibhavJain

Vector Embeddings and Vector search in PG
Vector Embeddings and Vector search in PG

presented by Pushkar Khadilkar , VaibhavJain from Google

This talk will look at the following aspects:

  • Integration with LLMs
  • Generation of vector embeddings
  • Persistence of vector embeddings
  • Approximate Nearest Neighbor (ANN) Search

10:50 - 11:30 Robusta + Arabica Database Engine Developers
11:35
Dinesh Kumar Chemuduru RK Rakesh

PostgreSQL I/O Patterns
Dive into PostgreSQL I/O

presented by Dinesh Kumar Chemuduru, RK Rakesh from Tessell

PostgreSQL I/O Patterns

In this talk, we would like to talk about PostgreSQL database systems I/O patterns. In PostgreSQL, we do have I/O patterns like

  • Checkpoint
  • Background Writer
  • Vacuum/Autovacuum
  • Client Backend
  • Bulk Read/Writes
  • WAL I/O
  • Query I/O
  • Query Parallel Reads
  • Index I/O

Also, dive deep into PostgreSQL catalog tables, which actually talks about ...

more

11:35 - 12:15 Robusta + Arabica Case Study
Shruthi K C

PostgreSQL 16: What's New? A comprehensive overview of the Latest Features

presented by Shruthi K C from EnterpriseDB

Title: PostgreSQL 16: What's New? A comprehensive overview of the Latest Features

PostgreSQL 16 is here, and it's packed with exciting new features and improvements! If you're eager to dive in and start using this latest version of one of the world's most powerful open-source databases, you're in the right place. In this talk, you will learn more about the key features and performance i...

more

11:35 - 12:15 Grand Victoria A Application Developer
Lalit Choudhary

PostgreSQL DBA's Troubleshooting Toolkit: Unraveling Complex Issues with Expertise.
PostgreSQL DBA's Troubleshooting Toolkit

presented by Lalit Choudhary from Percona

Objective: From this topic, DBA should know how to approach if they are looking for testing, reproducing issues, Health checks, and monitoring for PostgreSQL.

Talk abstract:

  • Introduction: The significance of testing and monitoring tools and why DBA needs them. 
  • Obstacles: Testing environment Provisioning, Time-consuming, and Monetary cost.
  • Solution:  Utilizing opensource...
more

11:35 - 12:15 Grand Victoria B Database Administration
12:20
Tom Howcroft

Unlocking financial DevOps: Navigating the FinOps landscape for cloud cost optimization in PostgreSQL

presented by Tom Howcroft from DBtune

In the dynamic realm of contemporary computing, Financial DevOps (FinOps) has emerged as a focal point, responding to the escalating challenges of cloud costs. Despite the initial promise of reduced infrastructure expenses, organizations are establishing FinOps departments to fine-tune the cost dynamics of cloud computing.

This presentation sheds light on the evolution of FinOps since its in...

more

12:20 - 13:00 Grand Victoria A Case Study
Jobin Augustine

Most Common Mistakes and the Cost of Mistakes One Should Be Aware
Most Common Mistakes and the Cost of Mistakes One Should Be Aware

presented by Jobin Augustine from Percona

###Introduction The presenter has a unique opportunity to address hundreds of real-world, escalated issues from different users as part of the job. This gave a realisation that many are often running into a group of common mistakes. It will be of great value if PostgreSQL users can understand the mistakes well ahead and avoid them during the system design, development and deployment.

C...

more

12:20 - 13:00 Robusta + Arabica Database Administration
Ben Darnell

Various Isolation Levels in Relational Database Management Systems
Various Isolation Levels in Relational Database Management Systems

presented by Ben Darnell from Cockroach Labs

Transaction isolation levels are officially defined in terms of which data anomalies they prevent. However, terms like “phantom read” are difficult to understand and are not helpful to most application developers trying to choose the right level. Fortunately, there are other ways of looking at isolation levels that can remove the confusion from this choice.

In this talk I will describe how t...

more

12:20 - 13:00 Grand Victoria B Database Administration
13:05
PGConf Organizers

Day 2 Lunch
Day 2 Lunch

presented by PGConf Organizers from PGConf India

Day 2 Lunch

13:05 - 14:00 Grand Victoria Other
14:00
Bruce Momjian

MVCC Unmasked

presented by Bruce Momjian from EnterpriseDB

Multi-Version Concurrency Control (MVCC) allows Postgres to offer high concurrency even during significant database read/write activity. MVCC specifically offers behavior where "readers never block writers, and writers never block readers". This talk explains how MVCC is implemented in Postgres and highlights optimizations which minimize the downsides of MVCC. This talk is for advanced users.

14:00 - 14:40 Grand Victoria B Database Engine Developers
Peter Farkas

Moving MongoDB Workloads to PostgreSQL

presented by Peter Farkas from FerretDB

MongoDB, a widely used database, has garnered both love and hate from its users across different industries due to its ease of use. However, it is no longer open source, faces licensing issues, and requires additional resources and knowledge to run. Is there a viable alternative? Can we move existing MongoDB workloads to Postgres without any application-level changes? How can we ensure MongoDB ...

more

14:00 - 14:40 Grand Victoria A Case Study
Varun Dhawan

Transforming PostgreSQL to API: A Simplified Journey with Data API Builder
Easy API Creation with PostgreSQL and Data API Builder

presented by Varun Dhawan from Microsoft

Dive into a realm of innovation where PostgreSQL meets modern API technologies, orchestrated by the versatile Microsoft’s open-source project Data API Builder (DAB). Tailored for PostgreSQL Application Developers, this session is set to unravel the seamless process of morphing PostgreSQL tables into dynamic REST/GraphQL APIs, sans the complexity of extensive programming or cum...

more

14:00 - 14:40 Robusta + Arabica Application Developer
14:45
Darshan Balar

Real Time Data processing using Go and PostgreSQL

presented by Darshan Balar from Indiamart

Abstract:

In the digital age, data flows incessantly, and for many applications, the ability to harness this continuous stream of information in real-time is the key to gaining valuable insights and staying competitive. To address this challenge, our presentation will delve into the captivating world of real-time data processing, shining a spotlight on the formidable combination of Go (Go...

more

14:45 - 15:25 Grand Victoria A Application Developer
Pavish Kumar R

Making PostgreSQL accessible to your non-technical colleagues

presented by Pavish Kumar R from Mathesar

Every application developer and DB admin comes across the scenario where you're expected to be an intermediary between the database and your non-technical colleagues.

Have you ever faced these situations:

  • Run queries to answer questions for business teams, and they often have a lot of questions.
  • Receive urgent emails asking us to fix something in production data, because a business t...
more

14:45 - 15:25 Robusta + Arabica Case Study
Avinash Shashikant Dalvi

Harnessing the power of Postgres for GIS
Using Postgres database for GIS case study

presented by Avinash Shashikant Dalvi from Eagleview

In this talk, we will discuss the benefits of using Postgres for GIS and how to harness the power of Postgres for your GIS applications. We will cover the following topics:

  • Overview of Postgres and PostGIS
  • Storing and querying geospatial data in Postgres
  • Using spatial indexing to improve performance
  • Building GIS applications with Postgres and PostGIS

We will also present a c...

more

14:45 - 15:25 Grand Victoria B Case Study
15:30
PGConf Organizers

Tea Break
Tea Break

presented by PGConf Organizers from PGConf India

Day 2 afternoon tea break

15:30 - 16:00 Grand Victoria Other
16:00
PGConf Organizers

Lightning Talks and Closing Note
Lightning Talks and Closing Note

presented by PGConf Organizers from PGConf India

Lightning Talks and Closing Note

16:00 - 17:00 Grand Victoria Other