Anayrat links

GitHub - levkk/pgcat: PostgreSQL pooler with sharding, load balancing and failover support.

PostgreSQL · pooler · rust

July 28, 2022 at 12:07:15 PM GMT+2 * · permalink

https://github.com/levkk/pgcat

GitHub - agroal/pgagroal: High-performance connection pool for PostgreSQL

PostgreSQL · pooler

July 28, 2022 at 12:00:51 PM GMT+2 * · permalink

https://github.com/agroal/pgagroal

SAR Charts

sysstat · sar

July 27, 2022 at 10:17:38 AM GMT+2 * · permalink

https://sarcharts.tuxfamily.org/

Loose Index Scan aka Skip Scan in PostgreSQL 🐘🚀 - DEV Community

PostgreSQL · loose_index_scan

July 26, 2022 at 10:20:19 PM GMT+2 * · permalink

https://dev.to/yugabyte/loose-index-scan-aka-skip-scan-in-postgresql-1jfo

Select the Most Recent Record (of Many Items) With PostgreSQL

PostgreSQL · loose_index_scan · TimescaleDB

July 26, 2022 at 10:18:56 PM GMT+2 * · permalink

https://www.timescale.com/blog/select-the-most-recent-record-of-many-items-with-postgresql/

Choosing a PostgreSQL Number Format

PostgreSQL · types

July 25, 2022 at 4:41:37 PM GMT+2 * · permalink

https://www.crunchydata.com/blog/choosing-a-postgresql-number-format

Guide pour trouver du matériel informatique reconditionné et recyclé

reconditionné

July 25, 2022 at 4:28:06 PM GMT+2 * · permalink

https://www.toolinux.com/?ou-trouver-du-materiel-informatique-reconditionne-et-recycle

Pleasant debugging with GDB and DDD

GDB

July 25, 2022 at 4:19:03 PM GMT+2 * · permalink

https://begriffs.com/posts/2022-07-17-debugging-gdb-ddd.html

Transaction anomalies with SELECT FOR UPDATE - CYBERTEC

PostgreSQL · MVCC · Isolation · SERIALIZABLE

July 19, 2022 at 4:08:59 PM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/transaction-anomalies-with-select-for-update/

Postgres Indexes, Selectivity, and Statistics

PostgreSQL · Statistics

July 19, 2022 at 4:08:31 PM GMT+2 * · permalink

https://www.crunchydata.com/blog/indexes-selectivity-and-statistics

Postgres 15 improves UNIQUE and NULL - Blog @ RustProof Labs

PostgreSQL · pg15

July 19, 2022 at 4:01:52 PM GMT+2 * · permalink

https://blog.rustprooflabs.com/2022/07/postgres-15-unique-improvement-with-null

Queries in PostgreSQL: 5. Nested loop : Postgres Professional

PostgreSQL · Join · nested_loop · memoize

July 19, 2022 at 3:31:32 PM GMT+2 * · permalink

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

Chris's Wiki :: blog/linux/PSINumbersAndMeanings

linux · Kernel · monitoring · PSI

July 4, 2022 at 3:59:42 PM GMT+2 * · permalink

https://utcc.utoronto.ca/~cks/space/blog/linux/PSINumbersAndMeanings

PostgreSQL 15 New Features With Examples (Beta 1)

PostgreSQL · pg15

June 28, 2022 at 11:17:54 PM GMT+2 * · permalink

https://h50146.www5.hpe.com/products/software/oe/linux/mainstream/support/lcc/pdf/PostgreSQL_15_Beta_1_New_Features_en_20220524-1.pdf

Common DB schema change mistakes | Database Lab · Instant clones of PostgreSQL databases · Postgres.ai

PostgreSQL · schema_migration

June 28, 2022 at 7:21:30 PM GMT+2 * · permalink

https://postgres.ai/blog/20220525-common-db-schema-change-mistakes

Creating a search catalog in PostgreSQL using full text indexing

PostgreSQL · FTS

June 28, 2022 at 6:48:25 PM GMT+2 * · permalink

https://www.youtube.com/watch?v=cN3h7bgCg_s

Benchmarking four Different Replication Solutions

PostgreSQL · multimaster · Replication · logique

June 28, 2022 at 6:45:07 PM GMT+2 * · permalink

https://www.postgresql.eu/events/pgconfde2022/sessions/session/3773/slides/297/benchmarking_four_replication_solutions-julian_markwort-pgconf_de-2022-05-13.pdf

Debugging deadlocks in PostgreSQL - CYBERTEC

PostgreSQL · deadlock · lock

June 28, 2022 at 6:21:22 PM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/debugging-deadlocks-in-postgresql/

Case-insensitive pattern matching in PostgreSQL - CYBERTEC

PostgreSQL · ICU

June 28, 2022 at 6:16:46 PM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/case-insensitive-pattern-matching-in-postgresql/

PostgreSQL at Scale: Database Schema Changes Without Downtime | by James Coleman | The PayPal Technology Blog | Medium

PostgreSQL · schema_migration

June 27, 2022 at 4:17:31 PM GMT+2 * · permalink

https://medium.com/paypal-tech/postgresql-at-scale-database-schema-changes-without-downtime-20d3749ed680