Anayrat links

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

QueryRecorder | GitLab

QueryRecorder is a tool for detecting the N+1 queries problem from tests.

gitlab · n+1 · ruby

April 30, 2018 at 7:48:08 PM GMT+2 * · permalink

https://docs.gitlab.com/ee/development/query_recorder.html

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

mermaid · GitBook

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

https://mermaidjs.github.io/

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/

Oracle. Tuning the Buffer Cache

Oracle · Internal

April 30, 2018 at 4:12:15 PM GMT+2 * · permalink

http://slideplayer.com/slide/4002724/

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/

How to get a core dump for a segfault on Linux - Julia Evans

GDB · valgrind · hack

April 29, 2018 at 5:57:06 PM GMT+2 * · permalink

https://jvns.ca/blog/2018/04/28/debugging-a-segfault-on-linux/

How does Stack Overflow do pagination? - Meta Stack Overflow

sql · offset

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

https://meta.stackoverflow.com/questions/322164/how-does-stack-overflow-do-pagination

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