Anayrat links

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

View permissions and row-level security in PostgreSQL - CYBERTEC

PostgreSQL · pg15 · Security · view

June 1, 2022 at 8:07:26 PM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/view-permissions-and-row-level-security-in-postgresql/

What’s new with io_uring

io_uring

June 1, 2022 at 8:06:24 PM GMT+2 * · permalink

https://kernel.dk/axboe-kr2022.pdf

Improving Postgres Connection Scalability: Snapshots - Microsoft Tech Community

PostgreSQL · connection

May 25, 2022 at 3:59:47 PM GMT+2 * · permalink

https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/improving-postgres-connection-scalability-snapshots/ba-p/1806462

Analyzing the Limits of Connection Scalability in Postgres - Microsoft Tech Community

PostgreSQL · connection

May 25, 2022 at 3:59:32 PM GMT+2 * · permalink

https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/analyzing-the-limits-of-connection-scalability-in-postgres/ba-p/1757266

Talk - Anthony Shaw: Write faster Python! Common performance anti patterns

Python · performance · profiling

May 25, 2022 at 10:48:48 AM GMT+2 * · permalink

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

Cancel a hanging PostgreSQL query - CYBERTEC

PostgreSQL · hack · Internal

May 24, 2022 at 10:13:21 PM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/cancel-hanging-postgresql-query/

Queries in PostgreSQL. Index scan / Habr

PostgreSQL · SQL · index · optimizer · planner

May 24, 2022 at 7:44:46 PM GMT+2 * · permalink

https://habr.com/en/company/postgrespro/blog/666974/

Postgres Query Optimization: LEFT JOIN vs UNION ALL

PostgreSQL · Tricks · optimizer · SQL

May 22, 2022 at 10:51:16 PM GMT+2 * · permalink

https://www.crunchydata.com/blog/postgres-query-optimization-left-join-vs-union-all

Speeding up sort performance in Postgres 15 - Microsoft Tech Community

PostgreSQL · pg15 · sort

May 20, 2022 at 9:57:06 AM GMT+2 * · permalink

https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/speeding-up-sort-performance-in-postgres-15/ba-p/3396953

5mins of Postgres E11: MERGE in Postgres 15, and how it compares to INSERT ON CONFLICT

PostgreSQL · MERGE · pg15

May 20, 2022 at 9:53:59 AM GMT+2 * · permalink

https://pganalyze.com/blog/5mins-postgres-15-merge-vs-insert-on-conflict