Search: [PostgreSQL] - Anayrat links

Unit testing functions in PostgreSQL with pgTAP in 5 simple steps

PostgreSQL · plpgsql · pgTAP

May 9, 2018 at 2:10:41 PM GMT+2 * · permalink

https://medium.com/engineering-on-the-incline/unit-testing-functions-in-postgresql-with-pgtap-in-5-simple-steps-beef933d02d3

The maze of the elephant

PostgreSQL · sql · constraint

May 9, 2018 at 2:04:06 PM GMT+2 * · permalink

http://www.pgdba.org/post/2018/05/dependency_maze/

PostgreSQL Data Types: Point

PostgreSQL · types · sql · GiST

May 7, 2018 at 2:25:06 PM GMT+2 * · permalink

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

avoid OR for better PostgreSQL query performance - Cybertec

PostgreSQL · sql

May 7, 2018 at 11:27:02 AM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/avoid-or-for-better-performance/

[ClusterLabs] Replicated PGSQL woes

PostgreSQL · HA

May 4, 2018 at 4:04:41 PM GMT+2 * · permalink

https://lists.clusterlabs.org/pipermail/users/2016-October/004342.html

Switchover/Switchback in PostgreSQL 9.3 | EnterpriseDB

PostgreSQL · HA

May 4, 2018 at 4:01:16 PM GMT+2 * · permalink

https://www.enterprisedb.com/node/3401

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