Sammlung von Newsfeeds

REGINA OBE: PostGIS Day 2023 Summary

Neues vom PostgreSQL Planet - 7. Dezember 2023 - 3:58

PostGIS Day 2023 videos came out recently. PostGIS Day conference is always my favorite conference of the year because you get to see what people are doing all over the world, and it always has many many new tricks for using PostgreSQL and PostGIS family of extensions you had never thought of. Most importantly it's virtual, which makes it much easier for people to fit in their schedules than an on site conference. We really need more virtual conferences in the PostgreSQL community.

muhammad ali: Understand Table Statistics Using pg_stat_all_tables

Neues vom PostgreSQL Planet - 6. Dezember 2023 - 18:14

Database monitoring, performance tuning and query optimization are critical operations for maintaining an efficient database system. A key component in PostgreSQL for this purpose is the pg_stat_all_tables view. pg_stat_all_tables offers real time statistics on table activities such as number of sequential and index scans performed on a table, updates, deletes, inserts, and more. It also […]

Bruce Momjian: In Praise of PostgreSQL

Neues vom PostgreSQL Planet - 6. Dezember 2023 - 15:30

At the risk of causing undue pride in the community, I want to share a blog post in praise of Postgres. This early paragraph captures his sentiments:

Elizabeth Garrett Christensen: PostGIS Day 2023 Summary

Neues vom PostgreSQL Planet - 6. Dezember 2023 - 14:00

We hosted our annual PostGIS day a couple weeks ago with some great talks on a big variety of topics within open-source GIS. Here is a summary of the themes I saw take shape across the day’s events that will point you towards the recordings, depending on your interests. A full playlist of PostGIS Day 2023 is available on our YouTube channel.

Pavel Stehule: Close cursors

Neues vom PostgreSQL Planet - 6. Dezember 2023 - 9:17

One my customer reported very problematic memory issues of currently tested code freshly ported from Oracle's PL/SQL to PL/pgSQL. He rewrites very big application based on usage of thousands stored procedures and functions, and views. This application is ported to Postgres by ora2pg. It is working pretty well, but some patterns has different overhead, and some patterns can be fatal.

In your application he often (100 000x) call code (in long transaction):

Julien Rouhaud: Extracting SQL from WAL? (part 1)

Neues vom PostgreSQL Planet - 6. Dezember 2023 - 4:04

Is it actually possible to extract SQL commands from WAL generated in “replica” wal_level?

The answer is usually no, the “logical” wal_level exists for a reason after all, and you shouldn’t expect some kind of miracle here.

But in this series of articles you will see that if some conditions are met you can still manage to extract some information, and how to do it. This first article focuses on the WAL records and how to extract the ones you want, while the next one will show how to try to extract the information contained in those records.

Pavlo Golub: PGSQL Phriday #014: Wrapping up!

Neues vom PostgreSQL Planet - 5. Dezember 2023 - 16:17

PGSQL Phriday #014: PostgreSQL Events

In my PGSQL Phriday #014 welcome post, I invited everyone to share their PostgreSQL event experiences in a dedicated blog post on December 1st. I am thrilled many people liked the idea and pitched in to make this event happen. Thanks to everyone!

Andrew L'Ecuyer: Announcing Crunchy Postgres for Kubernetes 5.5

Neues vom PostgreSQL Planet - 5. Dezember 2023 - 14:00

We're excited to announce the release of Crunchy Postgres for Kubernetes 5.5. Included in this release are great updates to database administration, monitoring, connection pooling and more. Specific highlights include:

Peter Eisentraut: PostgreSQL and FIPS mode

Neues vom PostgreSQL Planet - 5. Dezember 2023 - 6:00

PostgreSQL users sometimes ask whether PostgreSQL supports FIPS mode, whatever that might actually mean. “FIPS mode” is a thing provided by OpenSSL that, well, makes it more secure and prevents the use of old encryption methods, is I suppose a rough way to describe it? It has some interesting effects on PostgreSQL, which uses OpenSSL for various cryptographic purposes.

What is FIPS mode?

First, we should unpack what “FIPS mode” is.

Greg Sabino Mullane: Advent of Code in PostgreSQL: Tips and Tricks from 2022

Neues vom PostgreSQL Planet - 4. Dezember 2023 - 14:00

I’ve nearly finished solving the 2022 series in Advent of Code in PostgreSQL on our blog, many of these are available on our browser based Postgres playground as well. As many of you embark on your own Advent of Code adventures for 2023 this week, or maybe watch from afar, I wanted to pull together some themes, recommendations, tips, and tricks that I’ve seen work with the solutions.

Andrew Atkinson: PGSQL Phriday #014 — PostgreSQL Events

Neues vom PostgreSQL Planet - 3. Dezember 2023 - 1:00

This post is my contribution to the PGSQL Phriday #014 blog post series. Here’s the invitation:

I invite you to share your PostgreSQL Events experiences in your dedicated blog post. Whether you’re a seasoned attendee, a speaker, a trainer, a sponsor, an organizer, or a first-timer, your unique perspective contributes to the canvas of the PostgreSQL community.

Henrietta Dombrovskaya: PGSQL Phriday #014: Postgres Events!

Neues vom PostgreSQL Planet - 2. Dezember 2023 - 19:27

For this PGSQL Phriday, Pavlo Golub has chosen the topic “POSTGRESQL EVENTS”

Ryan Booz: Review: PostgreSQL at PASS Data Community Summit 2023

Neues vom PostgreSQL Planet - 1. Dezember 2023 - 20:51
PGSQL Phriday #014 is hosted by Pavlo Golub and we're talking about PostgreSQL events!

Claire Giordano: My Illustrated Guide to Postgres at PASS Data Summit 2023

Neues vom PostgreSQL Planet - 1. Dezember 2023 - 19:07

The topic of this month’s PGSQL Phriday #014 community blogging event—where people from different companies and different countries all blog about the same topic on the same day—is PostgreSQL Events. Big thanks to Pavlo Golub for organizing this month's PGSQL Phriday.

Michael Christofides: Some thoughts on Postgres events

Neues vom PostgreSQL Planet - 1. Dezember 2023 - 18:58

Photo from PGDay UK 2023, credit: Jimmy Angelakos

This month’s PGSQL Phriday topic, proposed by Pavlo Golub, is Postgres Events.

I recorded an episode of Postgres FM on this with Nikolay, but somehow even in 52 minutes I didn’t manage to cover a couple of things I wanted to share, so here we are.

Grant Fritchey: PostgreSQL Events – A Newbies Perspective: #PGSQLPhriday 014

Neues vom PostgreSQL Planet - 1. Dezember 2023 - 17:02

For this month’s #PGSQLPhriday 014 blogging event, Pavlo Golub has asked a pretty simple question: What do you think about PostgreSQL events? Prior to this year, I’d never attended an event focused on PostgreSQL. Heck, I’d never attended an event that had an intentional track or learning pathway, or whatever, focused on PostgreSQL. In the […]

semab tariq: PostgreSQL with Python – A Developer’s Guide

Neues vom PostgreSQL Planet - 1. Dezember 2023 - 12:52

This guide will delve into the seamless integration of PostgreSQL and Python, covering optimal connection methods and demonstrating how to execute CRUD operations (Create, Read, Update, Delete) efficiently within PostgreSQL using Python.

The post PostgreSQL with Python – A Developer’s Guide appeared first on Stormatics.

Jeremy Schneider: Seattle Postgres User Group and PASS Summit – PGSQL Phriday #014

Neues vom PostgreSQL Planet - 1. Dezember 2023 - 9:20

This month’s PGSQL Phriday #014 is about PostgreSQL Events, and it’s a great time to give an update about the Seattle Postgres User Group where I’ve been working together with long-time organizer Lloyd Albin. At the beginning of this year, I wrote about re-starting our meetups post-pandemic.

Ryan Lambert: Postgres Events: PgSQLPhriday #014

Neues vom PostgreSQL Planet - 1. Dezember 2023 - 6:01

It is PgSQLPhriday time again! This month's event is PgSQLPhriday (#014) and is hosted by Pavlo Golub. I'm barely making the deadline, but didn't want to miss this one! Pavlo chose PostgreSQL Events for the focus for this month's topic. See his post for the full details. As always, I can't wait to read the rest of the contributions this month.

Henrietta Dombrovskaya: A Video recording of Chicago PUG November meetup is now available!

Neues vom PostgreSQL Planet - 30. November 2023 - 20:20

I wanted to thank Dian Fay one more time for making coming to Chicago and presenting!

If you are interesed in trying her tool, please visit her GItLab repo: