Postgres Weekly 🐘@PostgresWeekly

Postgres / PostgreSQL news from the Postgres Weekly email newsletter.

 Sign up at the website ⬇️
Based in United Kingdom
postgresweekly.com/
Joined April 2013
237 Photos and videos
Filter
Exclude
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
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
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
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
Amazon Aurora Adds Postgres 14 Support: aws.amazon.com/about-aws/wha…
1
2
10
Load more