Postgres Weekly 🐘 (@PostgresWeekly) header
Postgres Weekly 🐘 (@PostgresWeekly) profile picture

Postgres Weekly 🐘

@PostgresWeekly

Postgres / PostgreSQL news from the Postgres Weekly email newsletter.

 Sign up at the website ⬇️
postgresweekly.com/
Joined April 2013
  • Tweets3.3K
  • Following70
  • Followers6.5K
📬 Join over 14,000 subscribers and get a free, weekly digest of #PostgreSQL news in your inbox: postgresweekly.com/
Image from Postgres Weekly 🐘 (@PostgresWeekly)
5
12
`\gexec` in `psql`: A Postgres Power User Practice? cybertec-postgresql.com/en/g…
gexec in psql: PostgreSQL poweruser practice

gexec in psql: PostgreSQL poweruser practice

gexec PostgreSQL poweruser practice: Learn how to use the gexec command and the `||` operator to get the best results out of your psql.

cybertec-postgresql.com
10
PostgreSQL 14 Internals: The Book - postgrespro.com/community/bo…
2
22
Working with `DISTINCT` in Postgres 15: percona.com/blog/introducing…
Introducing PostgreSQL 15: Working with SELECT DISTINCT

Introducing PostgreSQL 15: Working with SELECT DISTINCT

For those new to PostgreSQL, the SELECT DISTINCT statement eliminates duplicate rows from the result by matching specified expressions. Learn how it works here!

percona.com
3
17
Some Notes on GitLab’s Postgres Schema Design: shekhargulati.com/2022/07/08…
3
9
Data to Go: Postgres Logical Replication - crunchydata.com/blog/data-to…
Data To Go: Postgres Logical Replication | Crunchy Data Blog

Data To Go: Postgres Logical Replication | Crunchy Data Blog

Logical replication means you can take your data wherever you need it - for reporting, analytics, or testing. This is a tutorial on the basics of setting up logical replication.

crunchydata.com
2
4
Enabling and Enforcing SSL/TLS for Postgres Connections: percona.com/blog/enabling-an…
Enabling and Enforcing SSL/TLS for PostgreSQL Connections

Enabling and Enforcing SSL/TLS for PostgreSQL Connections

Enabling SSL in PostgreSQL is very straightforward and here go through the steps and check/validate the connections are indeed using the safer SSL protocol.

percona.com
9
Initial Findings from the State of PostgreSQL 2022 Survey: timescale.com/blog/state-of-…
2
4
Column Order in Postgres Does Matter: cybertec-postgresql.com/en/c…
Column order in PostgreSQL does matter

Column order in PostgreSQL does matter

Column order can determine how quickly your data is processed in PostgreSQL. Find out how to troubleshoot performance problems in wide tables

cybertec-postgresql.com
3
1
7
How Postgres 15 Improves `UNIQUE` and `NULL`: blog.rustprooflabs.com/2022/…
1
8
Transaction Anomalies with `SELECT FOR UPDATE`: cybertec-postgresql.com/en/t…
Transaction anomalies with SELECT FOR UPDATE

Transaction anomalies with SELECT FOR UPDATE

This article shows how surprising transaction anomalies can happen with SELECT FOR UPDATE and what you can to to avoid them.

cybertec-postgresql.com
1
12
How to Log Selects From a Specific Table? depesz.com/2022/07/04/how-to… (A practical introduction to using PGAudit. It's nice to have access to this sort of feature.)
2
8
Understanding `pg_stat_activity`: depesz.com/2022/07/05/unders…
8
PostgreSQL 15 Beta 2 Released: postgresql.org/about/news/po…
PostgreSQL 15 Beta 2 Released!

PostgreSQL 15 Beta 2 Released!

The PostgreSQL Global Development Group announces that the second beta release of PostgreSQL 15 is now [available for download](https://www.postgresql.org/download/). This …

postgresql.org
5
14
Google Cloud Spanner's Postgres Interface Goes GA: cloud.google.com/blog/produc…
Access Spanner’s global scale and high availability from familiar PostgreSQL | Google Cloud Blog

Access Spanner’s global scale and high availability from familiar PostgreSQL | Google Cloud Blog

The new PostgreSQL interface for Spanner, now GA, combines the scalability of Spanner with the portability of PostgreSQL for enterprise workloads.

cloud.google.com
3
7
Using Cloudflare Tunnel and Access with Postgres: blog.cloudflare.com/cloudfla…
Using Cloudflare Tunnel and Access with Postgres

Using Cloudflare Tunnel and Access with Postgres

How the Database team uses Cloudflare Tunnels internally to improve security and usability of adhoc DB queries

blog.cloudflare.com
1
8
pgenv 1.3: Postgres Binary Manger - github.com/theory/pgenv (Aims to make it simple to build and run different releases of Postgres, particularly for switching between them to test, etc.)
GitHub - theory/pgenv: PostgreSQL binary manager

GitHub - theory/pgenv: PostgreSQL binary manager

PostgreSQL binary manager. Contribute to theory/pgenv development by creating an account on GitHub.

github.com
8
Postgres Upgrades Are Hard: andreas.scherbaum.la/blog/ar…
6
Postgres Indexes, Selectivity, and Statistics: crunchydata.com/blog/indexes… (A look under the covers at some ways to tweak things when Postgres's query planning isn't quite up to par.)
Postgres' Clever Query Planning System | Crunchy Data Blog

Postgres' Clever Query Planning System | Crunchy Data Blog

Paul looks under the covers at Postgres query plans, indexes, filters, and statistics.

crunchydata.com
6
Postgres Weekly 🐘 retweeted
Ryan Booz (@ryanbooz) profile picture
Ryan Booz
@ryanbooz28 Jun 2022
The State of PostgreSQL 2022 survey will close in two days! Here are a few thoughts on interesting things we're learning and how you can add your voice, too! And, ALL anonymized data will be made available to everyone in a few weeks! softwareandbooz.com/the-2022…
The 2022 State of Postgres Survey is about to close! Take part and share your experience!

The 2022 State of Postgres Survey is about to close! Take part and share your experience!

It’s been quite an exciting month at Timescale for a number of reasons, but one of the biggest initiatives we’ve tackled is the third annual State of PostgreSQL survey. With approximately 45 questi…

softwareandbooz.com
4
1
6
Debugging Deadlocks in Postgres: cybertec-postgresql.com/en/d…
Debugging deadlocks in PostgreSQL

Debugging deadlocks in PostgreSQL

This article demonstrates debugging deadlocks techniques in PostgreSQL and applies them to an example test case.

cybertec-postgresql.com
7
17
Load more