@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
237Media
Include

Only show posts containing:

Exclude

Hide posts containing:

Time range
-
Minimum likes
`\gexec` in `psql`: A Postgres Power User Practice? cybertec-postgresql.com/en/g…

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

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

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 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 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

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!

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

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

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

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

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

crunchydata.com
6
Postgres Weekly 🐘 retweeted
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!

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

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

cybertec-postgresql.com
7
17
Load more