Anayrat links

Bloat and Fragmentation in PostgreSQL

HoT · Vacuum · PostgreSQL

December 12, 2018 at 1:29:54 PM GMT+1 * · permalink

https://www.slideshare.net/masahikosawada98/bloat-and-fragmentation-in-postgresql

Demi jointures - semi join

SQL · Postgis · Join

December 12, 2018 at 9:34:17 AM GMT+1 * · permalink

http://pgphil.ovh/semi_join_11_01.php

Hooks in PostgreSQL

hook · PostgreSQL · Internal · hack

December 11, 2018 at 12:20:14 PM GMT+1 * · permalink

https://www.pgcon.org/2012/schedule/attachments/243_Hooks%20in%20PostgreSQL

GitHub - AmatanHead/psql-hooks: Unofficial documentation for PostgreSQL hooks.

hook · PostgreSQL · hack · Internal

December 11, 2018 at 12:19:54 PM GMT+1 * · permalink

https://github.com/AmatanHead/psql-hooks

prepared transactions and their dangers - Cybertec

2PC · prepare · PostgreSQL

December 11, 2018 at 11:45:29 AM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/prepared-transactions/

Kubernetes in Production: Services – okmeter.io blog

Kubernetes · PostgreSQL

December 10, 2018 at 2:31:22 PM GMT+1 * · permalink

https://blog.okmeter.io/kubernetes-in-production-services-34c3234c94c8

Pagination Done the PostgreSQL Way

PostgreSQL · SQL · pagination · offset

December 10, 2018 at 1:46:41 PM GMT+1 * · permalink

https://leopard.in.ua/2014/10/11/postgresql-paginattion#.XA5gDk6Z3mE

AWS re:Invent 2018: [REPEAT 1] Deep Dive on Amazon Aurora with PostgreSQL Compatibility (DAT305-R1)

AWS · Aurora · PostgreSQL

December 9, 2018 at 6:27:57 PM GMT+1 * · permalink

https://www.youtube.com/watch?v=3PshvYmTv9M

Introducing Patroni as the Postgres Failover Manager on GitLab.com | GitLab

PostgreSQL · Patroni · HA · gitlab

December 9, 2018 at 6:27:12 PM GMT+1 * · permalink

https://about.gitlab.com/2018/12/05/availability-postgres-patroni/

Evaluating High Availability Solutions for TimescaleDB + PostgreSQL

PostgreSQL · Patroni · HA

December 9, 2018 at 6:16:57 PM GMT+1 * · permalink

https://blog.timescale.com/high-availability-timescaledb-postgresql-patroni-a4572264a831

Postgres 12 highlight - New PGXS options for isolation and TAP tests

PostgreSQL · Extension · tests

December 9, 2018 at 6:16:28 PM GMT+1 * · permalink

https://paquier.xyz/postgresql-2/postgres-12-pgxs-extension/

Trim command with SSD 400GB P3600 |Intel Communities

NVMe · storage · linux

December 5, 2018 at 9:53:27 PM GMT+1 * · permalink

https://communities.intel.com/thread/75161?start=0&tstart=0

Linux 4.20 I/O Scheduler Benchmarks On NVMe SSD Storage - Phoronix

NVMe · RAID · linux · storage

December 5, 2018 at 9:53:08 PM GMT+1 * · permalink

https://www.phoronix.com/scan.php?page=article&item=linux-420-io&num=1

Databases vs. encryption |

PostgreSQL · Encryption

December 5, 2018 at 8:33:53 PM GMT+1 * · permalink

https://blog.2ndquadrant.com/databases-vs-encryption/

Déployez vos machines virtuelles KVM sur Proxmox VE avec Cloud-Init

proxmox

December 5, 2018 at 8:28:25 PM GMT+1 * · permalink

https://jesuisadmin.fr/deployer-des-machines-virtuelles-kvm/

Energy-efficient I/O Thread Schedulers for NVMe SSDs on NUMA

NVMe · numa · Kernel · scheduler · linux

December 4, 2018 at 4:17:34 PM GMT+1 * · permalink

https://www.computer.org/csdl/proceedings/ccgrid/2017/6611/00/07973744.pdf

NUMA Best Practices for Dell PowerEdge 12th Generation Servers

numa · linux · Kernel

December 4, 2018 at 4:12:24 PM GMT+1 * · permalink

https://downloads.dell.com/solutions/general-solution-resources/White%20Papers/NUMA%20for%20Dell%20PowerEdge%2012G%20Servers.pdf

PostgreSQL query planner’s internals

PostgreSQL · planner · Statistics · Tricks

December 4, 2018 at 3:13:38 PM GMT+1 * · permalink

https://pgday.ru/presentation/170/59648e053f0f0.pdf

Power vs Performance · HewlettPackard/LinuxKI Wiki · GitHub

linux · tuning · Performance · Kernel · Internal

December 4, 2018 at 11:58:30 AM GMT+1 * · permalink

https://github.com/HewlettPackard/LinuxKI/wiki/Power-vs-Performance

Why the RDBMS is the future of distributed databases, ft. Postgres and Citus

PostgreSQL · citus

December 1, 2018 at 11:58:02 AM GMT+1 * · permalink

https://www.citusdata.com/blog/2018/11/30/why-rdbms-is-the-future-of-distributed-databases/