Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 1 Stunde 1 Minute

Ryan Booz: PostgreSQL Patch of Interest (to me): Transaction Timeout

21. Februar 2023 - 15:30
This is part of an occasional series of blogs about PostgreSQL commitfest patches. Look at the series intro which also lists some ground rules and expectations for what to expect in my thoughts below. 🐘 Patch title and thread: Transaction Timeout Commitfest at time of review: 2023-03 Status at time of review: Ready for Committer … Continue reading "PostgreSQL Patch of Interest (to me): Transaction Timeout"

Pavlo Golub: ER diagrams with SQL and Mermaid

21. Februar 2023 - 11:00
What does ER stand for?

An Entity Relationship (ER) diagram is one of the most important tools for database design. It helps you visualize the relationships between different entities and how they interact with each other. Many GUI tools have their own tools to build ER diagrams, e.g. pgAdmin IV, DBeaver, etc.

Luca Ferrari: PgTraining online webinar on 2023-04-14 (Italian)

21. Februar 2023 - 1:00

Yet another online event organized by PgTraining!

PgTraining online webinar on 2023-04-14 (Italian)

PgTraining, the amazin italian group of people that spread the word about PostgreSQL and that I joined in the last years, is organizing another online event (webinar) on next 14th April 2023.
Following the success of the previous edition(s), we decided to provide another afternoon full of PostgreSQL talks, in the hope to improve the adoption of this great database.

Andreas 'ads' Scherbaum: Frits Hoogland

20. Februar 2023 - 15:00
PostgreSQL Person of the Week Interview with Frits Hoogland: My name is Frits Hoogland, I am born, raised and living in Lutjebroek, which is a tiny village in the Netherlands (of which most people don’t know it actually exists). I am married to Suzanne and have a son named Jason.

Magnus Hagander: PGDay/MED 2023 - Schedule published and registration open

20. Februar 2023 - 9:30

We are pleased to announce that we have finalized the schedule for PGDay/MED 2023! We were fortunate enough to get a large number of submissions, and the program committee is proud of the line-up that we’re featuring for this first-ever Mediterranean PGDay.

Registration is open for the conference and we hope that you’ll be able to join us in St. Julian’s, Malta, on April 13. You can secure your ticket here.

We look forward to seeing you in April!

Henrietta Dombrovskaya: I have a question again – a different one

19. Februar 2023 - 15:46

On February 15, we had one more live meetup of the Chicago PostgreSQL User Group. I am very happy with how it went, except for one thing.

David E. Wheeler: Hello Mastodon 🐘

18. Februar 2023 - 23:53

Hey all you Postgres people out there! Just wanted to make a quick post regarding the PGXN twitter bot. In light of the recent announcements by Twitter to charge for API use, I udpated PGXN Manager to also post to Mastodon! If youre have joined the exodus to the Fediverse, give it a follow:

Greg Sabino Mullane: PostgreSQL Unlogged Tables - Look Ma, No WAL!

17. Februar 2023 - 17:00

While supporting customers at Crunchy Data, I sometimes see users add unlogged tables. In this post, I'm going to review some of the specifics about this.

Unlogged tables in Postgresql are a way of preventing specific tables from generating WAL (Write Ahead Log) information by adding the unlogged keyword to a create table command:

CREATE UNLOGGED TABLE foobar (id int);

You can also change existing tables to unlogged, and switch them back again:

Christophe Pettus: UUIDs vs serials for keys

17. Februar 2023 - 5:34

This topic pops up very frequently: “Should we use UUIDs or bigints as primary keys?”

One of the reasons that the question gets so many conflicting answers is that there are really two different questions being asked:

  • “Should our keys be random or sequential?”
  • “Should our keys be 64 bits, or larger?”

Let’s take them independently.

Should our keys be random or sequential?

There are strong reasons for either one. The case for random keys is:

Oliver Rice: Type Constraints in 65 lines of SQL

17. Februar 2023 - 1:12
Creating validated data types in Postgres

Christophe Pettus: “Database Patterns and How to Find Them” at SCaLE 2023

16. Februar 2023 - 6:47

I’ll be speaking on Database Antipatterns and How to Find Them at SCaLE 2023, March 9-12, 2023 in Pasadena, CA.

Christophe Pettus: “Extreme PostgreSQL” at PgDay/MED

16. Februar 2023 - 2:30

I’m very happy that I’ll be presenting “Extreme PostgreSQL” at PgDay/MED in Malta (yay, Malta!) on 13 April 2023.

Andreas Scherbaum: PostgreSQL 95

15. Februar 2023 - 21:36

Someone at FOSDEM 2023 asked the question: "What happens when PostgreSQL rolls over the version number to 95? Will this cause problems like back then in Windows?"

Ryan Booz: PostgreSQL Patch of Interest (to me): Using the System CA Pool for Certificate Verification

15. Februar 2023 - 15:00
This is part of an occasional series of blogs about PostgreSQL commitfest patches. Look at the series intro which also lists some ground rules and expectations for what to expect in my thoughts below. 🐘 Patch title and thread: Use the system CA pool for certificate verification Commitfest at time of review: 2023-03 Status at … Continue reading "PostgreSQL Patch of Interest (to me): Using the System CA Pool for Certificate Verification"

Pavlo Golub: Go & PostgreSQL: FOSDEM 2023 talk

15. Februar 2023 - 11:00

On the 5th of February 2023, I had the privilege of giving a talk at the PostgreSQL devroom during FOSDEM 2023 titled “When it all GOes right.” My talk focused on the process of creating programs in the Go language using a PostgreSQL database. It was an incredible opportunity to share my insights and experiences with fellow open-source enthusiasts from around the world, and to discuss the latest trends and developments in this rapidly evolving field.

Deepak Mahto: Get the most out of PostgreSQL using psql with must known features.

14. Februar 2023 - 14:43

If you’re a PostgreSQL user, you’re likely familiar with psql – the interactive terminal that connects you to your Postgresql databases. psql tool is more than just a basic utility. In fact, I consider it to be an essential asset for anyone working with PostgreSQL databases. With an impressive range of features, tips, and tricks, psql is go to tool to talk with PostgreSQL. It never fails to impress and surprise you with its incredible capabilities.

Lukas Fittl: Waiting for Postgres 16: Cumulative I/O statistics with pg_stat_io

14. Februar 2023 - 13:00
One of the most common questions I get from people running Postgres databases at scale is: How do I optimize the I/O operations of my database? Historically, getting a complete picture of all the I/O produced by a Postgres server has been challenging. To start with, Postgres splits its I/O activity into writing the WAL stream, and reads/writes to the data directory. The real challenge are second order effects around writes: Typically the write to the data directory happens after the transaction…

Hans-Juergen Schoenig: PostgreSQL: Finding the current timestamp

14. Februar 2023 - 10:00

PostgreSQL provides all kinds of time-related functions. But time is not as easy as it seems. One question many people keep asking: How can I find the current timestamp? What time is it?

While this seems like an easy question the answer isn’t as clear-cut as you might expect. Basically, there are three functions we might use to figure out what time it is:

Ryan Booz: PostgreSQL Patch of Interest (to me): An Occasional Blog Series

13. Februar 2023 - 19:45
PostgreSQL is the “Worlds Most Advanced Open Source Relational Database” (the website header says so, and I happen to agree). One of the reasons PostgreSQL popularity continues to increase is because of how new features, bug fixes, and general discussions about improving Postgres are open for anyone to see. Some changes are proposed and merged … Continue reading "PostgreSQL Patch of Interest (to me): An Occasional Blog Series"