Sammlung von Newsfeeds
Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 17 – ALTER TABLE command to change generation expression
You may have noticed a file called postmaster.pid inside your data directory. This file gets created when Postgres first starts up, and gets removed on a clean shutdown. It seems to contain some random numbers and strings, but what do they all mean?
The file will look like this:2757 /home/greg/pg/17/data 176540940 5432 /tmp * 8675309 12 ready
Here is a quick cheat sheet of the contents:
Today was the day - our PostgreSQL Query Optimization book was published! The book is currently available on Apress website, and if you are interested in the paper book, I believe that’s the fastest way to get it.
The PGConf.dev CFP closes on Monday, January 15 at 11:59pm PST, so if you want to speak at the inaugural PGConf.dev, submit a proposal!
PGConf.dev is the new PostgreSQL Development Conference, the successor to PGCon, a Postgres contribution-focused conference that took place every year in Ottawa. Pronounced "Pee-gee-conf-dot-dev", the inaugural year of PGConf.dev will take place in beautiful Vancouver, Canada, on May 28-31, 2024—with many of the same conference features that made PGCon so great:
Lukas Fittl: Introducing pg_query for Postgres 16 - Parsing SQL/JSON, Windows support, PL/pgSQL parse mode & more
There is no getting around “The Cloud”. We all know it, everybody is doing it!
And, let’s face it, if you are looking to get away from the hardship of having to go through troublesome and boring processes to get a new server or a new rack installed in your data center, this might help.
As of this writing, I know of three ways to make use of the incremental backup feature that I committed near the end of last month. I'll be interested to see how people deploy in practice. The first idea is to replace some of the full backups you're currently doing with incremental backups, saving backup time and network transfer.
You can cut-and-paste the following commands to quickly get a new & clean dev environment for working with PostgreSQL source code. This includes Michael Paquier’s powerful script kit for managing the PostgreSQL development environment.
Setting up from scratch takes me about 5 minutes, plus 3 minutes to configure, compile and install PostgreSQL for testing. Running the full PostgreSQL test suite (including TAP tests) took me 13 minutes.
I've always found distributed systems to be the most fascinating branch of computer science. I think the reason is that distributed systems are subject to the rules of the physical world just like we are. Things are never perfect, you cannot get everything you want, you’re always limited by physics, and often by economics, or by who you can communicate with. Many problems in distributed systems simply do not have a clean solution, instead there are different trade-offs you can make.
PostgreSQL is a robust open-source database management system, earning the distinction of DBMS of the Year 2023. Users choose for PostgreSQL due to various reasons, such as SQL support, Query Optimization, and Reliability, etc. In this blog, I will guide you through the process of setting up a TLS connection between a PostgreSQL server and the psql client using self-signed certificates. Here is the general view of the TLS connection setup.
Simon Riggs, a luminary in the PostgreSQL community and a strategic advisor to Stormatics, recently addressed the future trajectory of PostgreSQL recently addressed a keynote at PGConf EU...
The post The Next 20 Years of PostgreSQL: Embracing Better Persuasion appeared first on Stormatics.
Andrew Atkinson: The Rails Changelog — #014: PostgreSQL for Rails Developers with Andrew Atkinson 🎙️
Emmanuel has been landing top-notch guests from Ruby on Rails! Check out this look back at the Rails Changelog podcast guests from 2023.
Back in October I joined Jason, Andrew, and Chris, as a guest on Remote Ruby.
Remote Ruby is a podcast I listen to regularly, so it was a lot of fun to be a guest.
Some of the topics we discussed were my process of writing the book High Performance PostgreSQL for Rails, what’s trending in PostgreSQL now, storage access and database concepts, and of course some new things in Ruby on Rails.