Presentations
This talk will present a brief overview of Patroni and then discuss various deployment patterns (and possible issues with them) that we encountered while working with customers to implement PostgreSQL HA. In particular, it will discuss the following: synchronous standbys and/or read replicas, standby clusters for multi-region/availability zone replication, client fail-over possibilities and issues/solutions with DCS problems interfering with Patroni.
In this talk, we delve into the intricacies of payments engineering, covering challenges like avoiding double charges, reconciliation, and ensuring auditability. Drawing from these real-world scenarios, we explore how these lessons can be applied broadly to enhance software development practices and build reliable software.
According to Sam Altman, that's what OpenAI promises. Problem is, it can't deliver, because OpenAI is for AI in 2024 what IBM was for personal computers in 1974: still a mainframe company. As individuals, we know more about what we need from personal AI than any of the AI giants of today can guess at. And that's what Doc will talk about.
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, join methods, and execution plan interpretation.
When we talk about CI/CD, we often think of it as an end to end, linear, process. With modern cloud native computing, this ceases to be the case. The reality is your pipelines are hyperdimensional with many branches that can also have it’s own hyperdimension as well. This becomes a problem when dealing with GitOps workflows. Leading open-source GitOps platforms offer little to accommodate modern deployment pipelines. This talk will zero in on an alternative: patterns that address these challenges while remaining true to established GitOps principles.
How do you plan for unplanned incidents? You practice with Chaos Engineering. Strong incident response doesn't just happen, you have to build the skills and train your team. Practicing for major incidents gives your team insight into how your applications will behave when something goes wrong as well as how the team will interact to solve problems. Combining your Incident Response practices with Chaos Engineering roots your response practice in real-world scenarios, helping your team build confidence.
IPv6, the latest evolution of Internet Protocol, stands as the successor to IPv4. With its vast address pool, IPv6 connects a multitude of devices to the Internet while enhancing addressing and network traffic routing. With the depletion of free IPv4 addresses, organizations face the need to transition from IPv4 to IPv6 and acquire IPv6 address space for new networks. Are you prepared for the IPv6 transition but uncertain where to start? ARIN can guide you in determining the appropriate IPv6 address space for your organization.
Packagers in Linux distributions do a lot to ensure the software you use is up to date, integrated in the platform, and most importantly: works! But one package stands out among the others in importance: the Linux kernel. Over the past few years, I've become a Linux kernel package maintainer for a couple of Linux distributions (notably Fedora Asahi Remix and CentOS Stream Hyperscale). This talk will share my experiences in becoming and being a Linux kernel package maintainer: the good, the bad, and the sometimes ugly.
PostgreSQL uses memory for several purposes such as caching data (buffer cache), supporting user scenarios like query processing (work mem), as managed resource for internal use (memory context) and more. We will look at how each of these memory semantics are configured and used. Further we will dig into the internals of how PostgreSQL implements them accompanied with demos, tool usage and preview of work in progress.