Search: [PostgreSQL] - Anayrat links

PostgreSQL: Sharing data across function calls - Cybertec

plpgsql · PostgreSQL

May 3, 2018 at 11:05:46 AM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/postgresql-sharing-data-across-function-calls/

SERIALIZABLE in PostgreSQL 11... and beyond

PostgreSQL · Isolation · SERIALIZABLE · lock · skip

May 3, 2018 at 9:11:46 AM GMT+2 * · permalink

https://write-skew.blogspot.fr/2018/05/serializable-in-postgresql-11-and-beyond.html

PostgreSQL Data Types: ENUM

PostgreSQL · types · enum

May 2, 2018 at 1:23:44 PM GMT+2 * · permalink

https://tapoueh.org/blog/2018/05/postgresql-data-types-enum/

select * from depesz; » Blog Archive » Waiting for PostgreSQL 11 – Support partition pruning at execution time

PostgreSQL · partionning

May 1, 2018 at 7:58:39 PM GMT+2 * · permalink

https://www.depesz.com/2018/05/01/waiting-for-postgresql-11-support-partition-pruning-at-execution-time/

Issues related to PL/pgSQL usage

PostgreSQL · plpgsql · Performance

May 1, 2018 at 4:54:48 PM GMT+2 * · permalink

https://postgres.cz/files/plpgsql_issues.pdf

Severe site degradation due to database load - Google Docs

PostgreSQL · outage · gitlab

April 30, 2018 at 7:18:59 PM GMT+2 * · permalink

https://docs.google.com/document/d/1_IzyO-jwqb7UFl0A28D1gR4EaU99cEnoUSD9o8q4eZw/edit

Tech preview: PostgreSQL 11 - CREATE PROCEDURE - Cybertec

PostgreSQL · sql · plpgsql · procedure

April 30, 2018 at 4:42:01 PM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/tech-preview-postgresql-11-create-procedure/

PostgreSQL Data Types: JSON

PostgreSQL · JSON · types

April 30, 2018 at 4:41:45 PM GMT+2 * · permalink

https://tapoueh.org/blog/2018/04/postgresql-data-types-json/

Why Auto Increment Is A Terrible Idea - Clever Cloud Blog

uuid · PostgreSQL

April 30, 2018 at 4:10:08 PM GMT+2 * · permalink

https://www.clever-cloud.com/blog/engineering/2015/05/20/why-auto-increment-is-a-terrible-idea/

Benchmarking UUIDs, v2

PostgreSQL · uuid

April 30, 2018 at 4:04:35 PM GMT+2 * · permalink

https://jasonaowen.net/blog/2017/Apr/13/benchmarking-uuids-v2/

select * from depesz; » Blog Archive » Waiting for PostgreSQL 11 – Indexes with INCLUDE columns and their support in B-tree

PostgreSQL · Btree · index

April 27, 2018 at 5:29:03 PM GMT+2 * · permalink

https://www.depesz.com/2018/04/26/waiting-for-postgresql-11-indexes-with-include-columns-and-their-support-in-b-tree/

select * from depesz; » Blog Archive » Waiting for PostgreSQL 11 – Add json(b)_to_tsvector function

PostgreSQL · JSON · FTS

April 24, 2018 at 8:17:49 PM GMT+2 * · permalink

https://www.depesz.com/2018/04/23/waiting-for-postgresql-11-add-jsonb_to_tsvector-function/

PostgresConf US 2018 - ANSI, Schmansi! How I learned to stop worrying and love Postgres-isms

PostgreSQL · sql

April 23, 2018 at 5:58:42 PM GMT+2 * · permalink

https://sehrope.github.io/postgres-conf-2018-ansi-schmansi/#/

Data Egret: Let’s speed things up.

PostgreSQL · Parallel

April 23, 2018 at 5:36:58 PM GMT+2 * · permalink

http://blog.dataegret.com/2018/04/lets-speed-things-up.html

Testing Database Changes the Right Way - Heap | Mobile and Web Analytics

PostgreSQL · Performance · tests

April 23, 2018 at 5:32:52 PM GMT+2 * · permalink

https://heapanalytics.com/blog/engineering/testing-database-changes-right-way

xmax, its various meanings and how to tell them apart - Cybertec

PostgreSQL · Internal · MVCC · lock

April 23, 2018 at 12:37:07 PM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/whats-in-an-xmax/

PG Phriday: Securing PgBouncer | PgBouncer Authentication Simplified

PostgreSQL · PgBouncer

April 21, 2018 at 9:15:29 AM GMT+2 * · permalink

https://blog.2ndquadrant.com/pg-phriday-securing-pgbouncer/

NoSQL best practices for PostgreSQL // Speaker Deck

PostgreSQL · NoSQL · JSON

April 21, 2018 at 9:15:10 AM GMT+2 * · permalink

https://speakerdeck.com/erthalion/nosql-best-practices-for-postgresql

Managing PostgreSQL clusters with Patroni // Speaker Deck

PostgreSQL · HA · Patroni

April 21, 2018 at 9:14:54 AM GMT+2 * · permalink

https://speakerdeck.com/alexeyklyukin/managing-postgresql-clusters-with-patroni

PostgreSQL Data Types: Arrays

PostgreSQL · Array · sql

April 20, 2018 at 4:23:12 PM GMT+2 * · permalink

https://tapoueh.org/blog/2018/04/postgresql-data-types-arrays/