Postgres Conference 2024 Program

presented by Zak Tedder

Communication in the Tech world can be brutal. People are busy and things need to get done. All the tasks and moving parts can make it difficult to see the end goal or how it all comes together. This can also foster a very competitive environment, where Pug-eat-Pug and the last Frenchy standing wins the prize. However, there is a much faster and solid route to the goal: synergy. When all of the...

presented by Montana Low

The intersection of hardware advancements and machine learning (ML) innovations has deep implications for databases. The integration of GPUs into Postgres is a response to the growing demand for real-time, sophisticated data processing, enabling advanced analytics, machine learning model training, and inference with increasing tight latency constraints against increasingly large scale data. In ...

presented by Frank McSherry

As the world moves towards lower latency in operational workloads, a new opportunity is emerging for database architects to ask which query processing work in their database should be performed proactively, as data change, and which work should be performed reactively, as queries roll in. Naturally, to do this you will need a tool that integrates seamlessly with PostgreSQL and maintains your qu...

presented by Jignesh Shah

Developers love open source databases because they help enable innovation, collaboration, and the creation of technologies that solve today’s and tomorrow’s problems. As we at AWS have ramped up our collaboration with open source communities, like PostgreSQL, we have seen how open source innovations improve the experience of our customers and the broader community. This keynote highlights how A...

presented by Jignesh Shah

Postgres major version upgrades require planning. In this topic we look under the hood on how PostgreSQL major version upgrades can be upgraded with minimum downtime and then go over the operational best practices of doing these upgrades at scale with 100s to 1000s of databases.

presented by Peter Zaitsev

In the current era of cloud computing, gone are the days of managing single-app systems with a standalone database. Instead, we find ourselves responsible for overseeing complex systems containing hundreds of services and dozens of databases. What makes it even more challenging is the dynamic nature of these systems. Databases can now migrate between nodes, and their storage performance can be ...

presented by Denis Magda

Stored procedures have been a feature of Postgres for years. They were designed to let developers execute data or compute-intensive logic directly where the data lives—in the database—thereby reducing network latency. However, even in 2024, this relational database feature hasn’t gained widespread adoption within developer communities for various reasons.

PgCompute is a new client-side Postg...

presented by Frank McSherry

PostgreSQL's materialized views are a great tool to provide low-latency answers to complex queries – but did you know they could offer serializable consistency if you used cutting-edge streaming engines, many millions of dollars, and countless hours of work from talented systems engineers and academics? Oh, and I guess you could then also join them with arbitrarily complex queries over Kafka to...

presented by Tatiana Krupenya

What is the difference between your stable production and test databases? Data.

When your system is active, data changes very quickly. You have made a backup up, and the next hour, it won't match with the database anymore. You migrated the data from your old database to a new one, but while you are finalizing all processes, data stops being synchronized. Of course, you can compare the data ...

presented by Wanda He and Thuymy Tran

The performance of your PostgreSQL database might be affected for multiple reasons, such as hardware (CPU, memory, disk) sources, application access pattern, suboptimal query plans, and etc. This session presents use cases of common PostgreSQL performance problems, discusses approaches and methodologies for “peeling the onion”, and identifies solutions. Use cases cover include idle connections,...

presented by Kobus Wolvaardt

Our journey from large 200 database clusters on mirrored SSDs to smaller 20 to 40 databases per cluster and 4 to 10 clusters per machine on spin disks using ZFS. How we manage replication, how we backup 2500 DBs (hint ZFS snapshots) and just some of the fun things we saw on our journey.

presented by Amit Chauhan

I frequently use pg_hint_plan to gain insights into the query planner choices made by the optimizer, and sometimes to work around issues that arise in production. However, hinting is often a complex task, requiring multiple hints to fix an exact plan. We will explore practical examples of how to use pg_hint_plan in a predictable manner, while also gaining a better understanding of access paths,...

presented by David Wein

Amazon Aurora is a relational database service built for the cloud that provides unparalleled high performance and availability at global scale with full PostgreSQL compatibility. In this session, learn how Amazon Aurora Limitless Database enables applications to scale to millions of transactions per second across petabytes of data. Explore the architecture, distributed transaction management, ...

presented by Jan Wieck

Sequences and serial columns have been a problem when it comes to logical database replication since the days of Slony-I. In this talk we take a look at different ways to avoid replicating sequences in the first place and how Snowflake IDs can help solve the problem, especially as we move to multi-master systems.

presented by PostgresConf Organizers

Wednesday Lunch Wednesday Lunch Wednesday Lunch Wednesday Lunch Wednesday Lunch

presented by Dave Stokes

The learning curve for PostgreSQL can be nearly verticle for those caught up in the terminology. So if you find yourself stuck between MIN and CMAX, or have no idea what those things are, then you should be in this talk. This will be a gentle introduction for those new to PostgreSQL to some of the more common but no less obscure terminology that you will stumble over when trying to discern the ...

presented by Phillip Merrick

Today’s modern applications must be always on, always available, and serve a global user base that demands fast response times. A fully multi-master distributed database architecture is critical for organizations to meet these demands. In this talk, we will explore the core use cases that benefit from deploying PostgreSQL with asynchronous logical replication in a multi-region or even multi-clo...

presented by Chandra Pathivada

Join us to understand how these Isolation levels impact the consistency, concurrency, and reliability of your database transactions. demystify the complexities of PostgreSQL isolation levels, helps you to make informed decisions in managing data integrity within your applications.

presented by Biren Shah

Upgrading your highly available, high-load PostgreSQL databases can be a challenge on its own. When having customers around the globe with tight SLAs, the requirement arises to execute these upgrades with minimal or even without any downtime.

This talk walks through how we at GitLab evolved from multi-hour downtime windows to not causing any customer-facing interference at all.

presented by Drew Stevens

In the modern database ecosystem, there are a lot of offerings that implement some, most, or all of the PostgreSQL API. Google Cloud's hyper-scalar Spanner database is one of them. Fidelity to the PostgreSQL syntax and semantics is important to portability and participation in this ecosystem. Hear how we use a variety of testing approaches to validate that Spanner's support for PostgreSQL is ...

presented by Peter Zaitsev

Running PostgreSQL on Kubernetes is becoming increasingly popular, offering various methods for implementation. This talk will examine different operators that facilitate running PostgreSQL on Kubernetes. We'll also take a look at Neon PostgreSQL, specifically designed for cloud-native environments, and cover the most important best practices for effectively running PostgreSQL on Kubernetes.

presented by Gwen Shapira

Schema evolution, also known as “schema migrations” is a core part of application development and is considered one of the riskiest - with the potential to bring down entire production systems with one innocent mistake.

Schema evolution becomes especially tricky for SaaS, where the same application serves a large number of tenants. Regardless of whether the tenants share the same Postgres d...

presented by Charly Batista

In this session we'll unravel the intricacies of PostgreSQL's internal data organisation, shedding light on the Free Space Map (FSM) mechanism. Delving into the heart of PostgreSQL's data architecture, we'll explore ways to strategically reorganise the data model, capitalising on data alignment within blocks. The goal? To unveil techniques that not only optimise disk space usage but also enhanc...

presented by Manish Shah

With DBHawk, users only receive access to the data they need. DBHawk provides zero trust secure access to on-premises and cloud databases.

In this demo, you'll learn:

• How you can provide secure database access to your users. How to dynamically mask data and apply Object Access Control Policy.
• How to connect to PostgreSQL, Microsoft SQL Server, Azure SQL, Google Cloud SQL, AWS RDS, M...

presented by Yurii Rashkovskii

Postgres extension ecosystem is growing, and the capabilities of Postgres are growing with it.

But just as the extensions are pushing the boundaries of what's possible with Postgres, we've come to a point where we need to consider how much the extensions need to push the boundaries of Postgres' extension harnessing.

Let's talk about the limitations and constraints of the current extension...

presented by Chandra Pathivada

In this session, we delve into the common scenarios where PostgreSQL may not be utilizing indexes as expected, leading to suboptimal query performance. We explore the underlying reasons, such as query optimization, data distribution, and indexing strategies, that can impact index usage. Join us as we discuss practical solutions and best practices for diagnosing and rectifying these issues, ulti...

presented by Ibrar Ahmed

In the continuously evolving landscape of digital enterprises, ensuring uninterrupted service and data availability is not just a luxury, but a mandate. PostgreSQL, celebrated for its robustness and flexibility, offers myriad ways to implement High Availability (HA) and fault tolerance. However, with options comes complexity. This talk aims to demystify HA for PostgreSQL, guiding attendees thro...

presented by Richard Guo

This talk will focus on how the planner works from a developer’s view and elaborate on the process of converting a query tree to a plan tree in details.

We can divide the planning process into 4 phases: preprocessing, scan/join planning, post scan/join planning and postprocessing. In this talk, I will explain what stuff is performed in each phase and what is the motivation to perform that. T...

presented by PostgresConf Organizers

Amazon Web Services Sponsored Welcome Reception. Come meet fellow Postgres advocates and have a drink!

presented by Curt Kolovson

Title: Keynote “The Original Postgres Storage System” Speaker: Curt Kolovson https://www.linkedin.com/in/ckolovson/

This is a retrospective talk reflecting on my experience at UC Berkeley and my collaborations with Prof. Michael Stonebraker, both from 1980-81 when I earned my MS in Computer Science at UC Berkeley, and from 1986-1990 when I earned my PhD working under Prof. Stonebraker. The...

presented by Ravi Murthy

We're living in an exciting time for databases. The generative AI ("GenAI") boom is bringing a wave of innovation and transforming software development, and PostgreSQL is where the action is. We'll cover the key data and AI trends that we've seen in the past year, review the many ways that AI can be valuable for developers, DBAs and other database professionals, and outline our vision for the f...

presented by Gleb Otochkin

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

presented by Silas Marvin

Retrieval Augmented Generation (RAG) represents a cutting-edge approach in natural language processing (NLP) — combining the strengths of semantic search for contextual retrieval with the generative capabilities of large language models (LLMs) to produce highly relevant and nuanced text outputs. PostgreSQL is an ideal NLP platform for AI and ML applications with the pgml and pgvector extensio...

presented by Clay Jackson

The Accidental DBA – Strategies for today’s heterogeneous database environment Are you an Oracle DBA or developer? Have you been asked to work with PostgreSQL, or MySQL, or some other data platform? This presentation will give you some practical advice on how to make the transition. We’ll cover processes, reference material and tools that will ensure you can thrive in today’s heterogeneous ...

presented by Bjoern Rost

The generative AI boom is putting databases front and center, and PostgreSQL has emerged as the defacto standard for working with vectors, models, and data. In this first session in a half day of Google-led learning, we'll explore what PostgreSQL offers for gen AI developers, which PostgreSQL options are available on Google Cloud (with a focus on AlloyDB), and how to do a heterogeneous migratio...

presented by Dane Falkner

In the realm of database technologies, Aurora Postgres stands out for its robust performance, scalability, and reliability. However, leveraging its full potential requires a deep understanding of both foundational and advanced optimization strategies. This presentation, "Optimizing for Excellence: Advanced Performance Tuning Techniques for Aurora Postgres," is meticulously crafted for intermedi...

presented by Avinash Dalvi

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

presented by Ibrar Ahmed

Unraveling Multi-Master Replication in PostgreSQL: Architectures and Solutions

Abstract: PostgreSQL, one of the world’s most advanced open-source relational database management systems, has undergone significant evolution over the years, with its vast ecosystem continuously expanding to meet the diverse needs of the modern digital age. One area that has captured significant attention is dat...

presented by Nimesh Bhagat and Nilesh Junnarkar

In the second session of the half-day Google-led learning (which you can also attend as a standalone session), we'll focus on database administration in the cloud and AI era. We'll review how AlloyDB uses adaptive algorithms for vacuum management, storage management, memory management and query optimization, and how you can use AI to manage a database fleet and optimize individual database inst...

presented by Dave Stokes

Merge() was introduced in PostgreSQL 15 and a few unkind individuals have dismissed it as a fancy 'upcert'. But MEREGE() is more than that! If you run batch data, like cash register transaction logs, and need to reconcile them against your main table, MEREGE() becomes a fantastic tool to speed processing and make your life much easier.

presented by Bohan Zhang

Because of the design and implementation of Multi-Version Concurrency Control (MVCC) in Postgres, the old data accumulates during updates. Hence, the indispensable role of Postgres autovacuum, responsible for garbage collection of dead tuples, becomes crucial for ensuring database performance. However, effectively monitoring and tuning autovacuum is a non-trivial task. In this presentation, I w...

presented by Guyren Howe

Postgres is the only major database with an advanced type system.

Come to this talk to learn about common gotchas with Postgres types, and how to get the most out of row types; enumerated types, and user defined types to make your Postgres code simpler, more readable and more effective.

presented by Sundar Raghavan and Shayon Sanyal

The integration of pgvector into existing Online Transaction Processing (OLTP) systems represents a significant advancement in leveraging vector search capabilities within traditional database environments. This presentation is designed to educate database professionals on the thoughtful integration of pgvector into OLTP applications powered by PostgreSQL, ensuring enhanced functionalities with...

presented by Gleb Otochkin

In the third session of the half-day Google-led learning (which you can also attend as a standalone session), we'll get down to the business of building a gen AI app. We'll review the concepts of LLMs, vector databases, vector search, vector embeddings and Retrieval Augmented Generation (RAG), and learn about pgvector and related PostgreSQL technologies. We'll bring it all together with an Allo...

presented by Chirag Dave and Sami Imseih

Want to become a PostgreSQL performance monitoring star?

Come and explore the world of the PostgreSQL Cumulative Statistics System, a.k.a. the pg_stat views, and see how this system can give you insights on critical workload activity such as visibility into I/O activity and much more that can help in real-time troubleshooting as well as proactive monitoring.

In this talk, we will explore...

presented by PostgresConf Organizers

Thursday Lunch Thursday Lunch Thursday Lunch Thursday Lunch Thursday Lunch

presented by Gleb Otochkin

This session provides extra time to finish the AlloyDB GenAI hands-on lab.

presented by Rajan Palanivel

Companies get significant business value out of the data they’ve collected. But, they are facing challenges with staying compliant with data privacy regulations while processing and analyzing the data in Postgres.

Typically, privileged database users have cleartext access to regulated data, in violation of compliance regulations. But, Postgres doesn’t provide all of the capabilities necessa...

presented by Greg Dostatni

Effective lock management is important for any database’s performance and stability. This presentation offers an exploration of some pitfalls and solutions to the Lock Manager challenges related to large, high performance environments.

We begin by examining how table inheritance can multiply the number of locks, and how that can affect performance when dealing with more than 10,000 locks. We...

presented by Ryan Booz

Whether you are the DBA for an agile, sprint-based team, or a developer with DBA responsibilities, you may feel like there are development bottlenecks at every turn.

Managing migrations with your ORM of choice is easy but often highly manual, error-prone and hard to manage as the project grows. Or worse yet, maybe your schema and change management consists of poorly commented SQL scripts sav...

presented by Sridhar Ranganathan

In the fourth and final session of the half-day Google-led learning (which you can also attend as a standalone session), we'll look at databases and analytics integration. A PostgreSQL database is a great source of operational data for real-time analytics and decision making for your apps and analytics systems. We'll learn about federated queries, streaming data, and built-in analytics, and the...

presented by Sameer Malik

Customers are looking to migrate off Oracle due to Vendor lock-in, Punitive licensing which results in license audits. Customer are required to pay for Initial license costs, each new features and options require additional licenses and they must license for the peak load . PostgreSQL is , the world's most advanced Open Source Database” that supports all features of RDBMS. PostgreSQL's PL/pgSQL...

presented by Charly Batista

In the dynamic landscape of PostgreSQL management, robust monitoring is the cornerstone of maintaining a healthy and performant Postgres environment. This talk delves deep into the intricacies of PostgreSQL monitoring, addressing fundamental questions: What are the most crucial aspects to monitor within the database? How do these metrics relate to the underlying operating system? And, in a mark...

presented by Tracy Jenkins and Peter Celentano

Although the application layer is the portion the world accesses for many cloud architectures, it seems that we rarely consider how we can optimize our application for the database we’re using. When using any relational database engine, it’s important to consider not just schema design, but understanding how databases read and write data to their storage systems to ensure the application is man...

presented by Frits Hoogland

Linux and containers are similar in that they provide operating system resources such as memory and storage. These resources, along with CPU and networking, are key factors to achieve optimal performance. However, databases in general and therefore PostgreSQL too relies on high performance disk IO to function properly. This widely known.

In this session, we'll explore how memory allocation a...

presented by Michael Meskes

For the first time in history almost everyone uses Open Source, albeit often without getting the benefits of Free Software. Open Source has accomplished unparalleled success in the IT industry, but with success comes challenges and risks. Over recent decades we have seen business models change while the industry and the users found the best ways to use Open Source. With Software as a Service we...

presented by Varun Dhawan

In a rapidly evolving digital landscape; choosing the right managed service for your PostgreSQL database is crucial. Azure Database for PostgreSQL stands out as a leading option; offering a blend of High Performance; Reliability; Security; and advanced features. This session delves into what sets Azure Database for PostgreSQL apart as a compelling choice for hosting PostgreSQL databases. We wil...

presented by Janis Griffin

Performance tuning can be complex. It’s often hard to know which knob to turn or button to press to get the biggest performance boost. This presentation will detail five steps to identify performance issues and resolve them quickly. Attendees at this session will learn how to fine-tune a SQL statement quickly; identify performance inhibitors to help avoid future performance issues; recognize co...

presented by Johann Schleier-Smith

Many software developers hesitate to choose Postgres because running it well can be challenging. While it is easy to get started, at certain levels of scale or application complexity it becomes challenging to set the 300+ Postgres configuration knobs properly.

From the early days of databases, people have sought to automate their configuration and administration. These efforts gained tractio...

presented by Mohamed Ali

PG Collector is a powerful open-source tool (https://github.com/awslabs/pg-collector) that gathers valuable PostgreSQL performance details and presents it in a simple report. If you are a DBA, come and learn how PG Collector can help reduce your mean Time to Know (MTTK) and help you gain deep insights into the health of your PostgreSQL database.

presented by Nikita Shamgunov

How Postgres needs to change to support modern application workloads

presented by Robert Bernier

Scaling PostgreSQL is a big deal but it doesn't have to be hard. There was a time when the only way scaling PostgreSQL was to design the architecture entirely on your own and basically figure out the entire life-cycle before even putting it into production. Since those early days a lot of technologies and processes have come into being that can guide one to creating, growing and maintaining a ...

presented by Varun Dhawan

Join this session to learn how to use PostgreSQL and OpenAI together to make smart AI applications. In this session, you will gain practical experience in configuring, and integrating OpenAI with PostgreSQL to create cutting-edge AI applications. We'll cover everything in two main parts:

Module 1: Setting Up and Starting Development

• Learn how to get PostgreSQL ready for use, includi...

presented by Chirag Dave and Sami Imseih

Partitioning divides table into smaller parts which helps in improving database performance and scalability. In PostgreSQL there not so obvious reason why you want to partition your table effectively to improve scalability, optimize the performance and management of your database.

In this talk we will discuss Vacuuming, caching benefits, and multi-tenancy with respect to partitioning. You w...

presented by Tim Steward

If like most developers, you are using a relational database as part of your digital landscape, then you will likely be required to manage the migration of data from a legacy system to a new platform at some point.

Data migration can be a lot more complicated than you expect. Poor planning, making too many assumptions, and a lack of testing are just SOME of the reasons why a data migration m...

presented by Yurii Rashkovskii

People mostly think of Postgres as a database. But because of its extensibility, it can already do so much more.

Except that wasn’t enough for us. We set out to extend Postgres to become a comprehensive platform for data-intensive applications and built Omnigres, a constellation of extensions. They allow building polyglot applications right on top of Postgres, with a simple goal: building fa...

presented by Srinivasa Inaganti

• Importance of log_line_prefix
• Log_connections and log_disconnections
• HBA rules - trust vs md5 vs ident vs scram
• Functions - INVOKER vs DEFINER
• User access control
• RDS SNS events , security groups etc..
• Data breach anatomy
• SSL tips

presented by Peter Farkas

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

presented by Denis Magda

OpenAI's GPT neural network can be enhanced and customized with plugins. For instance, the Expedia plugin arms the AI with current data on lodging prices and availability, allowing users to book their next trip directly through the ChatGPT interface.

In this session, you'll gain practical experience with large language models (LLMs) by creating a Postgres-backed plugin for the OpenAI platfor...

presented by Ryan Booz

As your database grows, the performance and maintenance of large tables can become challenging. Fear not! PostgreSQL has the right tool for the job: declarative table partitioning. In this talk, I will explore the benefits of partitioning in PostgreSQL, including improved performance and simplified maintenance.

After introducing the benefits of table partitioning, I’ll discuss the different ...

presented by Patrick Mottram

The massive interest in AI solutions recently sparked a huge wave of AI projects. We now enter a second phase where valid AI projects look for operational enterprise environments, as shown by the big hype for vector databases and feature stores. This phase is the hour of databases, the recognised bedrock for enterprise data management environments, where Postgres is a front runner. AI workloads...

presented by Clay Jackson

Data movement is a transformative force in today's digital landscape, enabling organizations to unlock the true value of data. Successful data movement requires a comprehensive data governance strategy that encompasses data selection, understanding, quality, mapping, schema development, and serialization.

Data governance is the key to unlocking the power of data movement, ensuring accurate, ...

presented by Alvaro Hernandez

Containers are everywhere. Whether in a code test suite, a developer's laptop, in production or CI/CD pipelines, containers have taken the deployment world by storm. Similarly, Kubernetes adoption is skyrocketing.

How does Postgres fit in this container era? Is Postgres "cloud native"?

The challenges to optimally run Postgres in containers will be explored, including the challenges associ...

presented by Mason Sharp and Jonah Harris

Syntax discrepancies. Data type mismatches. Application rewrites. These daunting pain points are faced by every developer and DBA considering a migration between database vendors. In this session, we'll dive into a revolutionary PostgreSQL extension that directly addresses these challenges, positioning PostgreSQL as the future of MySQL.

Much like AWS Babelfish for SQL Server, this extension ...

presented by PostgresConf Organizers

Friday Lunch Friday Lunch Friday Lunch Friday Lunch Friday Lunch Friday Lunch

presented by Gwen Shapira

Transactions are a key part to many modern databases, relational and non-relational systems alike. At a basic level, transactions allow us to treat a series of operations as a single unit. The reason transactions are so important is because they provide guarantees that developers can then use as assumptions when writing code. This means that there are entire set of concerns that you, the develo...

presented by Gleb Otochkin and Alan Li

The Vector data type is one of the most used data types for the latest AI applications prototypes and implementations. It is commonly used in applications such as image retrieval, natural language processing, and recommender systems. Vector search is a technique used to find similar vectors in a high-dimensional space and how we do it has a direct impact on the system performance. We will disc...

presented by Billy VanCannon

Encryption is widely accepted as a very powerful access control mechanism and the only one directly applied to data. Despite this, it isn’t as widely used as it could be. Using the PCI-DSS security framework for payment card data, we will investigate what it says about encryption regarding audit scope and securing credit card information. We will show the role of encryption can be expanded t...

presented by Conrad Hofmeyr

Local-first app development has some significant advantages over the cloud-first app development paradigm. For app developers, having local access to data simplifies state management and removes the bottleneck of waiting for API or backend functionality. For end-users, local data provides an instantly reactive UI since there is no need to wait for network requests and apps keep working through ...

presented by Min-Hank Ho

Businesses want to leverage private data for GenAI because it can save them time, money, and resources. They can also derive new insights and use their data for a competitive advantage. Postgres plays an important role in enabling GenAI applications, not only as a vector database provider through the use of extensions like pgvector, but also as the data source at the beginning of GenAI pipeline...

presented by Samuel Hu

PostgreSQL, renowned as the world's most popular OLTP database, stands at the forefront of transaction data workloads. However, this presentation will elaborate on why PostgreSQL dominates in the realm of Retrieval-Augmented Generation (RAG) systems too, highlighting its versatility and ecosystem in handling not only bounded, but even further, unbounded data. The presentation contains a live. ...

presented by BAJI SHAIK

Ensuring data security is paramount, especially in industries governed by HIPAA compliance. However, migrating encryption protocols from Oracle to PostgreSQL presents unique challenges due to their divergent methodologies. In this presentation, we delve into a compelling case study of a customer grappling with the intricacies of 2-level encryption migration. Explore the nuances of Oracle's encr...

presented by Sai Srirampur

pg_dump and pg_restore are reliable tools for backing up and restoring Postgres databases. They are widely used for various real-world use cases, including Database Migrations, Disaster Recovery, and more.They offer fine grain control, allowing selection of specific db objects for backup and restore, choice of dump format (plain text or compressed), and parallel processing of multiple tables....

presented by Perren Walker

This training will cover some of the most popular PostgreSQL extensions, their use cases and a deep dive into their usage. Gain a comprehensive understanding of PostgreSQL extensions and their role in expanding database functionalities.

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

Learn prac...

presented by Ibrar Ahmed

As businesses grow and data traffic intensifies, PostgreSQL database systems are often thrust into the spotlight, faced with the critical challenge of accommodating increasing workloads. In the database realm, scalability is the magic word. But how does one choose between vertical (scaling up) and horizontal (scaling out) scalability? And more importantly, how are these effectively implemented ...

presented by Sai Srirampur

Every datastore is unique with a diverse set of features and data modeling characteristics. For example, PostgreSQL has 4 ways to ingest data, 5 ways to read data, 300+ data types and 300+ database configs. Building data movement solutions that scale, therefore, requires an emphasis on the unique design and capabilities of each data store.

However, most existing data movement tools focus on ...