Anayrat links

Exclusive backup method is deprecated - what now? - Cybertec

PostgreSQL · Pitr · Backup

February 25, 2019 at 4:32:34 PM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/exclusive-backup-deprecated-what-now/

Postgres Job Queues & Failure By MVCC — Brandur Leach

PostgreSQL · MVCC · queues

February 25, 2019 at 12:40:38 PM GMT+1 * · permalink

https://brandur.org/postgres-queues

Integrated cache invalidation for better hit rates

PostgreSQL · pgQ

February 25, 2019 at 10:29:21 AM GMT+1 * · permalink

https://www.hagander.net/talks/cache_invalidation_2014.pdf

Parallel queries in PostgreSQL - Percona Database Performance Blog

PostgreSQL · Performance · Parallel

February 22, 2019 at 12:50:10 PM GMT+1 * · permalink

https://www.percona.com/blog/2019/02/21/parallel-queries-in-postgresql/

How Well a Query Optimizer Handles Subqueries? – Striving for Optimal Performance

PostgreSQL · planner

February 21, 2019 at 11:19:49 AM GMT+1 * · permalink

https://antognini.ch/2017/12/how-well-a-query-optimizer-handles-subqueries/

YOW2018 Cloud Performance Root Cause Analysis at Netflix

linux · benchmark · BPF · eBPF · perf

February 21, 2019 at 10:33:40 AM GMT+1 * · permalink

https://www.slideshare.net/brendangregg/yow2018-cloud-performance-root-cause-analysis-at-netflix

Pub-Sub avec Postgres

PostgreSQL · Python · queues

February 21, 2019 at 10:33:28 AM GMT+1 * · permalink

https://bersace.cae.li/postgres-agent-message-dramatiq.html

GitHub - pjungwir/postgres-temporal-talk: My talk about Postgres and Temporal Databases

PostgreSQL · SQL · temporal · PERIOD

February 19, 2019 at 4:41:42 PM GMT+1 * · permalink

https://github.com/pjungwir/postgres-temporal-talk

AMD EPYC and vSphere vNUMA - frankdenneman.nl

hardware · epyc · numa

February 19, 2019 at 3:49:18 PM GMT+1 * · permalink

http://frankdenneman.nl/2019/02/19/amd-epyc-and-vsphere-vnuma

WITH Queries: Present & Future

PostgreSQL · CTE · pg12

February 18, 2019 at 10:33:33 AM GMT+1 * · permalink

https://info.crunchydata.com/blog/with-queries-present-future-common-table-expressions

plprofiler - Getting a Handy Tool for Profiling Your PL/pgSQL Code - Percona Database Performance Blog

PostgreSQL · flamegraph · plpgsql

February 17, 2019 at 3:26:07 PM GMT+1 * · permalink

https://www.percona.com/blog/2019/02/13/plprofiler-getting-a-handy-tool-for-profiling-your-pl-pgsql-code/

PostgreSQL 11 Reestablishes Window Functions Leadership

PostgreSQL · Window_function

February 15, 2019 at 11:25:52 AM GMT+1 * · permalink

https://modern-sql.com/blog/2019-02/postgresql-11

How to Calculate a Cumulative Percentage in SQL – Java, SQL and jOOQ.

PostgreSQL · Window_function

February 14, 2019 at 6:45:05 PM GMT+1 * · permalink

https://blog.jooq.org/2019/02/14/how-to-calculate-a-cumulative-percentage-in-sql/

Introduction to Hacking PostgreSQL

PostgreSQL · hack · Internal

February 14, 2019 at 12:38:00 PM GMT+1 * · permalink

http://www.neilconway.org/talks/hacking/ottawa/ottawa_slides.pdf

Inside the PostgreSQL Query Optimizer

PostgreSQL · Internal · hack · planner · optimizer

February 14, 2019 at 12:37:20 PM GMT+1 * · permalink

http://www.neilconway.org/talks/optimizer/optimizer.pdf

PostgreSQL Deep Dive: How Your Data Model Affects Storage

PostgreSQL · SQL · Performance

February 13, 2019 at 9:52:33 PM GMT+1 * · permalink

https://info.crunchydata.com/blog/how-your-postgresql-data-model-affects-storage

What’s up with SET TRANSACTION SNAPSHOT?

PostgreSQL · MVCC

February 12, 2019 at 12:56:38 PM GMT+1 * · permalink

https://thebuild.com/blog/2019/02/11/whats-up-with-set-transaction-snapshot/

Performance Tuning and Analysis of Red Hat Enterprise Linux 7

linux · Kernel · irq · tuning · numa

February 12, 2019 at 12:13:45 PM GMT+1 * · permalink

http://people.redhat.com/jmario/presentations/rhcc.Feb2015/rhcc_performance.2-26-2015.pdf

Security Best Practices Deep Dive

PostgreSQL · Security

February 9, 2019 at 3:33:22 PM GMT+1 * · permalink

https://joeconway.com/presentations/SecurePGDeepDive-FOSDEM-2019.pdf

Queues in PostgreSQL

PostgreSQL · queues

February 7, 2019 at 3:41:40 PM GMT+1 * · permalink

http://2017.pgday.com.au/assets/queues-pgday-au-2017.pdf