Anayrat links

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/

Adjusting maintenance_work_mem - Cybertec

maintenance_work_mem · PostgreSQL

November 30, 2018 at 10:59:17 AM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/adjusting-maintenance_work_mem/

Managing High Availability in PostgreSQL — Part I – Kristi Anderson – Medium

PostgreSQL · HA · PAF

November 29, 2018 at 12:07:08 PM GMT+1 * · permalink

https://medium.com/@kristi.anderson/managing-high-availability-in-postgresql-part-i-21a6c1e6d6d8

Transactions in PostgreSQL: READ COMMITTED vs. REPEATABLE READ - Cybertec

PostgreSQL · Isolation · MVCC

November 29, 2018 at 12:04:57 PM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/transactions-in-postgresql-read-committed-vs-repeatable-read/

Combining pgBackRest and Streaming Replication | pgstef’s blog

pgbackrest · PostgreSQL

November 29, 2018 at 12:04:39 PM GMT+1 * · permalink

https://pgstef.github.io/2018/11/28/combining_pgbackrest_and_streaming_replication.html

Sequential UUID Generators |

uuid · PostgreSQL

November 28, 2018 at 10:23:38 AM GMT+1 * · permalink

https://blog.2ndquadrant.com/sequential-uuid-generators/

Waiting for PostgreSQL 12 – Integrate recovery.conf into postgresql.conf – select * from depesz;

PostgreSQL · v12

November 28, 2018 at 10:07:35 AM GMT+1 * · permalink

https://www.depesz.com/2018/11/27/waiting-for-postgresql-12-integrate-recovery-conf-into-postgresql-conf/

Beyond EXPLAIN - Query Optimization From Theory To Code

PostgreSQL · Statistics

November 23, 2018 at 11:21:59 AM GMT+1 * · permalink

https://www.pgcon.org/2016/schedule/attachments/433_PGCON2016_beyond_explain.pdf

How to Aggregate an Archive Log’s Deltas into a Snapshot with SQL – Java, SQL and jOOQ.

PostgreSQL · SQL

November 20, 2018 at 10:17:59 AM GMT+1 * · permalink

https://blog.jooq.org/2018/11/16/how-to-aggregate-an-archive-logs-deltas-into-a-snapshot-with-sql/

AUTO PLAN TUNING USING FEEDBACK LOOP

PostgreSQL · planner · Statistics · pg_plan_advsr

November 19, 2018 at 4:12:50 PM GMT+1 * · permalink

https://www.postgresql.eu/events/pgconfeu2018/sessions/session/2132/slides/143/PGConfEU2018_auto_plan_tuning_by_Tatsuro_Yamada.pdf

PostgresSQL: Implicit vs. explicit joins - Cybertec

PostgreSQL · Join

November 19, 2018 at 2:18:28 PM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/postgressql-implicit-vs-explicit-joins/

Postgres 11 partitioning | Denish Patel

PostgreSQL · partionning · pg11

November 16, 2018 at 6:02:08 PM GMT+1 * · permalink

http://www.pateldenish.com/2018/11/postgres-11-partitioning.html

PGDay UK 2016 -- Performace for queries with grouping

PostgreSQL · tuning · SQL · Hash · loose_index_scan

November 14, 2018 at 2:19:48 PM GMT+1 * · permalink

https://www.slideshare.net/AlexeyBashtanov/pgday-uk-2016-performace-for-queries-with-grouping

On the benefits of sorted paths |

PostgreSQL · SQL · tuning · Hash

November 14, 2018 at 2:07:40 PM GMT+1 * · permalink

https://blog.2ndquadrant.com/on-the-benefits-of-sorted-paths/