Program for PGConf India, 2024

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...

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. ...

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...

presented by Abhijeet Rajurkar from Google

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

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...

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....

presented by Sibu Behera from Google

Checkout the slides

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 roo...

presented by Franck Pachot from Yugabyte

Checkout the slides

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 c...

presented by Alexander Kukushkin from Microsoft

Checkout the slides

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 do...

presented by Tushar Amrit from Bloomberg

Checkout the slides

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 paramo...

presented by Timofey Kulin from YDB

Checkout the slides

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 l...

presented by Jelte Fennema-Nio from Microsoft

Checkout the slides

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 ...

presented by Nishchay Kothari from Fujitsu

Checkout the slides

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 wit...

presented by Ashutosh Bapat from EnterpriseDB

Checkout the slides

Checkout the Video

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 t...

presented by Shalaka Dengale, Ramya Bhat from AWS

Checkout the slides

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 i...

presented by Rohan Kumar from

Checkout the slides

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,...

presented by Luigi Nardi from DBtune

Checkout the slides

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 configuri...

presented by Sameer Mannava from Indian Institute of Technology Bombay

Checkout the slides

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 di...

presented by Ujjwal Gupta from SquadStack

Checkout the slides

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 c...

presented by VaibhavJain, Pushkar Khadilkar from Google

Checkout the slides

strong text This talk will look at the following aspects:

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

presented by Lalit Choudhary from Percona

Checkout the slides

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...

presented by Shruthi K C from EnterpriseDB

Checkout the slides

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 database...

presented by Ben Darnell from Cockroach Labs

Checkout the slides

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. Fort...

presented by Tom Howcroft from DBtune

Checkout the slides

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 ...

presented by Varun Dhawan from Microsoft

Checkout the slides

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 seam...

presented by Peter Farkas from FerretDB

Checkout the slides

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...

presented by Pavish Kumar R from Mathesar

Checkout the slides

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 bus...

presented by Darshan Balar from Indiamart

Checkout the slides

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 thi...