Anayrat links

Using jq to get information out of pgbackrest – Luca Ferrari – Open Source advocate, human being

pgbackrest

September 10, 2021 at 17:35:21 GMT+2 * · permalink

https://fluca1978.github.io/2021/09/10/pgbackrest-jq.html

A Rust PostgreSQL Extension for CAS Numbers | Depth-First

PostgreSQL · rust · Extension

September 10, 2021 at 09:04:59 GMT+2 * · permalink

https://depth-first.com/articles/2021/09/07/a-rust-postgresql-extension-for-cas-numbers/

How to build a job queue with Rust and PostgreSQL

PostgreSQL · rust

September 9, 2021 at 09:18:07 GMT+2 * · permalink

https://kerkour.com/blog/rust-job-queue-with-postgresql/

How We Went All In on sqlc/pgx for Postgres + Go

PostgreSQL · golang

September 9, 2021 at 09:17:25 GMT+2 * · permalink

https://brandur.org/sqlc

Postgres Extensions in Rust | Depth-First

PostgreSQL · Extension · rust

September 9, 2021 at 09:17:04 GMT+2 * · permalink

https://depth-first.com/articles/2021/08/25/postgres-extensions-in-rust/

Index bloat reduced in PostgreSQL v14 - Cybertec

PostgreSQL · HoT · index · pg14

September 8, 2021 at 13:29:38 GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/index-bloat-reduced-in-postgresql-v14/

Introduction · Linux Inside

linux · Internal · Kernel

September 6, 2021 at 10:53:23 GMT+2 * · permalink

https://0xax.gitbooks.io/linux-insides/content/

Notes on some PostgreSQL implementation details

PostgreSQL · subtransaction · multixact · pg_stat_slru · lock

September 1, 2021 at 14:29:38 GMT+2 * · permalink

https://buttondown.email/nelhage/archive/notes-on-some-postgresql-implementation-details/

PostgreSQL Subtransactions and performance - Cybertec

PostgreSQL · pg_stat_slru · xact · MVCC · subtransaction · multixact

September 1, 2021 at 14:01:38 GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/subtransactions-and-performance-in-postgresql/

PostgreSQL Subtransactions Considered Harmful | Database Lab · Fast clones of PostgreSQL databases · Postgres.ai

PostgreSQL · pg_stat_slru · xact · MVCC · subtransaction · multixact

September 1, 2021 at 13:54:49 GMT+2 * · permalink

https://postgres.ai/blog/20210831-postgresql-subtransactions-considered-harmful

Container Runtimes : C'est quoi ?

Docker

August 30, 2021 at 10:24:19 GMT+2 * · permalink

https://www.grottedubarbu.fr/container-runtimes-c-est-quoi/

Intro to Kernel and Userspace Tracing Using BCC, Part 1 of 3

bcc · eBPF · linux · Kernel · perf

August 28, 2021 at 11:45:31 GMT+2 * · permalink

https://blogs.oracle.com/linux/post/intro-to-bcc-1

GitHub - michelp/pgsodium: Modern cryptography for PostgreSQL using libsodium.

PostgreSQL · Encryption · Security · tde

August 26, 2021 at 15:34:56 GMT+2 * · permalink

https://github.com/michelp/pgsodium

A UNIQUE experience - Simple Talk

SQL · modelisation · celko · primary-key

August 24, 2021 at 10:32:07 GMT+2 * · permalink

https://www.red-gate.com/simple-talk/sql/learn-sql-server/a-unique-experience/

Performance of Various EBS Storage Types in AWS - Percona Database Performance Blog

AWS · EBS · storage

August 23, 2021 at 09:18:04 GMT+2 * · permalink

https://www.percona.com/blog/performance-of-various-ebs-storage-types-in-aws/

Postgres query execution: simple query - prepared statement - DEV Community

PostgreSQL · Internal · prepare

August 12, 2021 at 10:32:38 GMT+2 * · permalink

https://dev.to/yugabyte/postgres-query-execution-simple-query-prepared-statement-3kk0

How PostgreSQL aggregation works

PostgreSQL · TimescaleDB · Aggregate · SQL

August 10, 2021 at 17:03:19 GMT+2 * · permalink

https://blog.timescale.com/blog/how-postgresql-aggregation-works-and-how-it-inspired-our-hyperfunctions-design-2/

Locks in PostgreSQL: 1. Relation-level locks : Postgres Professional

PostgreSQL · lock

August 9, 2021 at 21:45:34 GMT+2 * · permalink

https://postgrespro.com/blog/pgsql/5967999

Locks in PostgreSQL: 2. Row-level locks : Postgres Professional

PostgreSQL · lock · MVCC · multixact

August 9, 2021 at 21:45:21 GMT+2 * · permalink

https://postgrespro.com/blog/pgsql/5968005

Locks in PostgreSQL: 3. Other locks : Postgres Professional

PostgreSQL · lock · , · advisory_locks · SERIALIZABLE

August 9, 2021 at 21:45:08 GMT+2 * · permalink

https://postgrespro.com/blog/pgsql/5968020