Search: [PostgreSQL] - Anayrat links

Check Your Privileges - The PostgreSQL Role System

PostgreSQL · Privileges · not_read

July 11, 2024 at 12:49:17 PM GMT+2 * · permalink

https://thebuild.com/presentations/cyp.pdf

https://tech.instacart.com/creating-a-logical-replica-from-a-snapshot-in-rds-postgres-886d9d2c7343

PostgreSQL · logique · Upgrade

July 6, 2024 at 11:25:23 AM GMT+2 * · permalink

https://tech.instacart.com/creating-a-logical-replica-from-a-snapshot-in-rds-postgres-886d9d2c7343

Gestion des permissions sous PostgreSQL

PostgreSQL · Privileges · Permissions

July 2, 2024 at 5:30:17 PM GMT+2 * · permalink

https://blog.dalibo.com/2024/06/28/permission.html

https://postgresql.verite.pro/blog/2024/07/01/pg17-utf8-collation.html

PostgreSQL · pg17 · ICU · Collation

July 2, 2024 at 2:09:13 PM GMT+2 * · permalink

https://postgresql.verite.pro/blog/2024/07/01/pg17-utf8-collation.html

Online upgrade of replication clusters without downtime

PostgreSQL · Upgrade · logique · pg17 · pg_createsubscriber

June 25, 2024 at 3:22:38 PM GMT+2 * · permalink

https://www.pgevents.ca/events/pgconfdev2024/sessions/session/20/slides/22/ONLINE%20UPGRADE%20OF%20REPLICATION%20CLUSTERS%20WITHOUT%20DOWNTIME_submit.pdf

PostgreSQL 17 and beyond

PostgreSQL · pg17

June 25, 2024 at 2:39:40 PM GMT+2 * · permalink

https://www.pgevents.ca/events/pgconfdev2024/sessions/session/52/slides/36/PostgreSQL%2017%20and%20beyond_conf.pdf

Reduce Vacuum by Using “ON CONFLICT” Directive | 🛩️ Shane Borden's Technology Blog

PostgreSQL · constraint · _on_conflict

June 25, 2024 at 1:29:24 PM GMT+2 * · permalink

https://stborden.wordpress.com/2024/06/18/reduce-vacuum-by-using-on-conflict-directive/

Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 1 – PL/pgSQL | Database and Migration Insights

PostgreSQL · pg17 · plpgsql

June 9, 2024 at 9:22:17 AM GMT+2 * · permalink

https://databaserookies.wordpress.com/2024/06/08/exploring-postgresql-17-a-developers-guide-to-new-features-part-1-pl-pgsql/

On analyse la nouvelle collation de PostgreSQL 17

PostgreSQL · pg17 · Collation

June 9, 2024 at 9:16:53 AM GMT+2 * · permalink

https://blog-postgresql.verite.pro/2024/06/07/pg17-utf8-collation.html

Collations from A to Z

PostgreSQL · Collation · pg17 · ICU

June 4, 2024 at 10:05:21 PM GMT+2 * · permalink

https://www.pgevents.ca/events/pgconfdev2024/sessions/session/95/slides/26/pgcon24_collation.pdf

Default Sort Order in Db2, SQL Server, Oracle & Postgres 17 | Ardent Performance Computing

PostgreSQL · pg17 · Collation

May 22, 2024 at 8:20:41 PM GMT+2 * · permalink

https://ardentperf.com/2024/05/22/default-sort-order-in-db2-sql-server-oracle-postgres-17/

Improve selectivity estimation for assorted match-style operators.

PostgreSQL · Internal · planner · pg13

May 19, 2024 at 10:30:30 AM GMT+2 * · permalink

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=a80818605e5447b9b846590c3d3fab99060cb53e

Making a Postgres query 1,000 times faster - Mattermost

Row Constructor Comparison

https://dba.stackexchange.com/questions/241591/postgres-choosing-a-filter-instead-of-index-cond-when-or-is-involved

TL;DR : x > a OR (x == a AND y > b) to (x, y) > (a, b)

PostgreSQL · optimizer · Tricks · SQL · not_read · row

May 18, 2024 at 9:24:54 PM GMT+2 * · permalink

https://mattermost.com/blog/making-a-postgres-query-1000-times-faster/

cursor_tuple_fraction and PostgreSQL JDBC | CYBERTEC PostgreSQL | Services & Support

cursor_tuple_fraction · PostgreSQL · jdbc

May 7, 2024 at 11:58:13 AM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/cursor_tuple_fraction-in-postgresql-jdbc/

Transforming and Analyzing Data in PostgreSQL - Simple Talk

PostgreSQL · SQL · CTE · Window_function

April 25, 2024 at 1:30:38 PM GMT+2 * · permalink

https://www.red-gate.com/simple-talk/databases/postgresql/transforming-and-analyzing-data-in-postgresql/

Zero Downtime PostgreSQL Major Version Upgrades

PostgreSQL · Upgrade · logique · Replication · gitlab

April 24, 2024 at 10:07:45 PM GMT+2 * · permalink

https://postgresconf.org/system/events/document/000/002/180/2024-04-postgresconf-PostgreSQL-Zero-Downtime-Postgres-Upgrades-at-GitLab.pdf

https://postgresconf.org/system/events/document/000/002/091/pg_hint_plan_-_get_the_right_plan_without_surprises.pdf

PostgreSQL · Extension · pg_hint_plan

April 24, 2024 at 9:51:40 PM GMT+2 * · permalink

https://postgresconf.org/system/events/document/000/002/091/pg_hint_plan_-_get_the_right_plan_without_surprises.pdf

Waiting for Postgres 17: Faster B-Tree Index Scans for IN(...) lists and ANY =

PostgreSQL · skip · loose_index_scan · pg17

April 23, 2024 at 5:33:05 PM GMT+2 * · permalink

https://pganalyze.com/blog/5mins-postgres-17-faster-btree-index-scans

Recursive CTEs: Transforming and Analyzing Data in PostgreSQL, Part 3 - Simple Talk

PostgreSQL · CTE · RECURSIVE

April 22, 2024 at 1:11:45 PM GMT+2 * · permalink

https://www.red-gate.com/simple-talk/databases/postgresql/recursive-ctes-transforming-and-analyzing-data-in-postgresql-part-3/

A Deeper Look Inside PostgreSQL Visibility Check Mechanism - Highgo Software Inc.

PostgreSQL · MVCC

April 21, 2024 at 9:36:24 PM GMT+2 * · permalink

https://www.highgo.ca/2024/04/19/a-deeper-look-inside-postgresql-visibility-check-mechanism/