Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 1 Stunde 8 Minuten

Shayon Mukherjee: Introducing pg_easy_replicate 2.0

29. Dezember 2023 - 17:53
It’s exciting to share that pg_easy_replicate, a project I’ve been maintaining, has hit a new milestone with its 2.0 release! This tool is more than a practical solution for setting up logical replication between PostgreSQL databases—it’s been a profound source of learning about PostgreSQL concepts for me. Engaging with the community and discovering the ways they use pg_easy_replicate has been equally satisfying, making this journey an enjoyable and insightful experience.

Umair Shahid: IT Budget for 2024: Tune Your PostgreSQL Before Upsizing Your Hardware

29. Dezember 2023 - 14:43

Learn how to maximize your existing resources, boost performance, and achieve sustainable growth without breaking the bank.

The post IT Budget for 2024: Tune Your PostgreSQL Before Upsizing Your Hardware appeared first on Stormatics.

Jobin Augustine: Human Factors Behind Incidents: Why Settings Like “idle_session_timeout” Can Be a Bad Idea

29. Dezember 2023 - 14:42
PostgreSQL 14 introduced the parameter [crayon-6596e09a7a5de463948439-i/], and, unfortunately, many DBAs jumped to start using it without understanding or by ignoring the consequences. In a short span of time, it has become one of the most misused parameters in many PostgreSQL installations. There is nothing wrong with [crayon-6596e09a7a5e7580417234-i/]  from a technical perspective; even without this parameter, […]

Hubert 'depesz' Lubaczewski: Proper support for I/O Timings on explain.depesz.com

29. Dezember 2023 - 13:20
Very long time ago (in PostgreSQL 9.2) we got ability to get, from EXPLAIN, information how long Pg spent on I/O operations. Reads and writes. Over the years situation has changed. Originally it looked like this: I/O Timings: read=15.792 write=26.804 This told us that Pg spend 15.8ms reading from disk, and 26.8ms writing. In Pg … Continue reading "Proper support for I/O Timings on explain.depesz.com"

Henrietta Dombrovskaya: Our PG Conf Talk: So, You Want To Have a PG Day In Your City?

29. Dezember 2023 - 6:11

Yet another disadvantage of a conference happening in December: first, you do not have time to blog about it, and then, nobody has time to read your posts because everybody is busy celebrating all possible holidays!

Dmitry Dolgov: Demand the impossible: rigorous database benchmarking

29. Dezember 2023 - 1:00
Everyone knows benchmarking is hard (and writing about benchmarking is double as hard), but have you ever asked 'why'? There could be at least few reasons, and they usually have something to do with the inherent duality: it's necessary to combine expertise from both the domain specific area and general analytics expertise; one have to take into account both known and unknown factors. In this article we try to use this as a base to answer the following: how to not blow up your PostgreSQL benchmark?

muhammad ali: Checkpoints, Background Writer and how to monitor it using pg_stat_bgwriter

27. Dezember 2023 - 17:48

Understand Checkpoints and how they differ from background writer in PostgreSQL. Learn how to monitor them using pg_stat_bgwriter view.

The post Checkpoints, Background Writer and how to monitor it using pg_stat_bgwriter appeared first on Stormatics.

Pavlo Golub: The Golden Trunk 2023 Award: My Playful Ode to Bloggers

27. Dezember 2023 - 16:40

Because Who Needs Another Gold Statue Anyway?

In the world of databases, where seriousness often reigns supreme… Well, you know me! I always want to inject a bit of humor and fun. Welcome to the inaugural “Golden Trunk 2023” award – my impulsive celebration of PostgreSQL community brilliance, where a golden elephant trunk steals the spotlight. Inspired by the grandeur of events like the Oscars and Globes, the “Golden Trunk” award was born – a celebration of the best articles about PostgreSQL!

Umair Shahid: Distributed Data in PostgreSQL with postgres_fdw: A Guide to Enhanced Performance and Flexibility

26. Dezember 2023 - 17:31

PostgreSQL Foreign Data Wrapper, is a built-in extension that allows seamless access and query data stored in external PostgreSQL databases as if it were local to your current database.

The post Distributed Data in PostgreSQL with postgres_fdw: A Guide to Enhanced Performance and Flexibility appeared first on Stormatics.

Robert Bernier: Grafana Dashboards: A PoC Implementing the PostgreSQL Extension pg_stat_monitor

26. Dezember 2023 - 14:23

This PoC demonstrates how to install and configure pg_stat_monitor in order to extract useful and actionable metrics from a PostgreSQL database and display them on a Grafana dashboard.

Jimmy Angelakos: PGConf.EU 2023 — Unforgettable moments and how we rocked the house!

22. Dezember 2023 - 18:45

This year, the 13th annual PostgreSQL Conference Europe (PGConf.EU for short) took place from December 12th to December 15th in the beautiful Central European city of Prague.

Before the main conference begins, there is a full day of training delivered by expert PostgreSQL professionals from all over the industry.

Gabriele Bartolini: CloudNativePG: The Most Popular Postgres Operator in 2023

22. Dezember 2023 - 9:50
Timescale has just announced the results of its 2023 State of PostgreSQL survey, the fourth of its kind, with responses from almost 900 individuals. As proud partners of this initiative, EDB is pleased to share some key findings that shed light on the dynamic landscape of this database engine. [Continue reading...]

Andreas Scherbaum: PGConf.EU 2023 Review

22. Dezember 2023 - 2:16

PGConf.EU 2023 is over, time for my personal review of the conference. Overall we got good and very good feedback, for most parts. Just the coffee …

oded valin: 5 Ways to implement NOT EXISTS in PostgreSQL

21. Dezember 2023 - 16:48

When building an application, usually we query our database to retrieve the things we already know: what orders a client made or, more generally, what steps in the app flow have already been taken. However, to correctly address the user journey, it is often more important to query the database and retrieve data that informs us about what is missing: an item not yet in the basket, a missing email confirmation, or a pending payment. Understanding and addressing these missing steps is crucial to optimize the user experience and to drive app adoption.

Shayon Mukherjee: Do you really need Foreign Keys?

21. Dezember 2023 - 15:25
Before we dive in, let’s set the stage with a few pointers: YMMV. There’s no one-size-fits-all. My insights are primarily drawn from my experience of handling large-scale, high-transaction Ruby on Rails / Go applications backed by PostgreSQL. I am not here to tell you Foreign Keys are bad. They are great. This post isn’t about that. If there’s one takeaway I’d love for you to have from this post, it’s this: Revisit your database schemas with a critical eye.

Christoph Berg: The 2023 PGconf.EU in Prague

21. Dezember 2023 - 10:05

Most of CYBERTEC’s employees are spread over central and Eastern Europe, so we rarely get to see each other in person, except for the ubiquitous video calls that have become common nowadays. Going to conferences is the best way to meet, and among them, the annual PGconf.EU conference is the best and biggest opportunity.

Robert Haas: Praise, Criticism, and Dialogue

20. Dezember 2023 - 19:05
When my children were little and I was trying to figure out how to be a parent, I read someplace that you need to have five positive interactions with your child for each negative one to maintain a good relationship. I don't know whether that is fact or myth; a quick Google search suggests that the origin of the idea was in a study about how married couples argue, the idea being that in a good marriage, positive things continue to happen even amidst disagreement.

Nickolay Ihalainen: Using Huge Pages with PostgreSQL Running Inside Kubernetes

20. Dezember 2023 - 17:49

Huge pages make PostgreSQL faster; can we implement it in Kubernetes? Modern servers operate with terabytes of RAM, and by default, processors work with virtual memory address translation for each 4KB page. OS maintains a huge list of allocated and free pages to make slow but reliable address translation from virtual to physical.

Andreas 'ads' Scherbaum: FOSDEM PGDay 2024 - FOSDEM PGDay + FOSDEM Devroom Schedule and Registration

20. Dezember 2023 - 17:44

We are pleased to announce that we have finalized the schedule for FOSDEM PGDay + FOSDEM Devroom!

Registration is open for the PGDay on Friday, you do not need a registration for the Devroom on Sunday. However based on experience, plan some time for the queue in front of the Devroom.

Christopher Winslett: Using acts_as_tenant for Multi-tenant Postgres with Rails

20. Dezember 2023 - 14:00

Since its launch, Ruby on Rails has been a preferred open source framework for small-team B2B SaaS companies. Ruby on Rails uses a conventions-over-configuration mantra. This approach reduces common technical choices, thus elevating decisions. With this approach, the developers get an ORM (ActiveRecord), templating engine (ERB), helper methods (like number_to_currency), controller (ActiveController), directory setup defaults (app/{models,controllers,views}), authentication methods (has_secure_password), and more.

Seiten