Anayrat links

AWS re:Invent 2017: How Netflix Tunes EC2

linux · Kernel · Performance

January 8, 2018 at 9:00:45 PM GMT+1 * · permalink

http://www.brendangregg.com/blog/2017-12-31/reinvent-netflix-ec2-tuning.html

PostgreSQL notes: Recursive queries vs standard ORM

PostgreSQL · CTE

January 8, 2018 at 8:27:28 PM GMT+1 * · permalink

https://tech.npras.in/postgres-recursive-query/

Some little known PostgreSQL/PostGIS tips & tricks - Intronautics 101

PostgreSQL · Postgis · Tricks · SQL · Performance

January 8, 2018 at 8:22:52 PM GMT+1 * · permalink

https://abelvm.github.io/sql/sql-tricks/

Decrypting PgBouncer’s Diagnostic Information - Heap Blog

PgBouncer

January 8, 2018 at 8:21:55 PM GMT+1 * · permalink

https://heap.engineering/decrypting-pgbouncers-diagnostic-information/

SQL Keys in Depth

SQL · PostgreSQL

January 8, 2018 at 8:21:13 PM GMT+1 * · permalink

https://begriffs.com/posts/2018-01-01-sql-keys-in-depth.html

Synacor Challenge

Programming

January 8, 2018 at 1:19:21 PM GMT+1 * · permalink

https://challenge.synacor.com/

Validation, Verification, and Modification - Simple Talk

SQL

December 28, 2017 at 10:00:13 PM GMT+1 * · permalink

https://www.red-gate.com/simple-talk/sql/sql-development/validation-verification-modification/

A perf cheat sheet - Julia Evans

perf

December 28, 2017 at 10:00:01 PM GMT+1 * · permalink

https://jvns.ca/blog/2017/12/27/a-perf-cheat-sheet/

Mettre à jour PostgreSQL pour améliorer les performances

PostgreSQL · Hash · Performance

December 28, 2017 at 9:46:15 PM GMT+1 * · permalink

http://pgphil.ovh/migration_performance_96_10_11_devel_01.php

Large objects ou bytea: les différences de verrouillage

PostgreSQL · bytea · SQL

December 27, 2017 at 4:31:26 PM GMT+1 * · permalink

http://blog-postgresql.verite.pro/2017/12/27/large-objects-bytea-verrous.html

PostgreSQL: How to speed up GROUP BY and joins

PostgreSQL · optimizer · Join · SQL · Aggregate

December 27, 2017 at 1:43:12 PM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/postgresql-speeding-up-group-by-and-joins/

Visualize PostgreSQL index file with pgdfv – bdt's blog

PostgreSQL · Internal

December 23, 2017 at 11:43:53 AM GMT+1 * · permalink

https://bdrouvot.wordpress.com/2017/12/21/visualize-postgresql-index-file-with-pgdfv/

Setting up psql, the PostgreSQL CLI

psql · PostgreSQL

December 22, 2017 at 6:31:58 PM GMT+1 * · permalink

http://tapoueh.org/blog/2017/12/setting-up-psql-the-postgresql-cli/

Oracle on VMware

Oracle · vmware · numa

December 22, 2017 at 11:21:30 AM GMT+1 * · permalink

https://www.performing-databases.com/wp-content/uploads/2017/12/Klier-Oracle-on-VMware.pdf

Walking with the Elephant: Partition-wise joins: "divide and conquer" for joins between partitioned table

PostgreSQL · partionning · Join

December 19, 2017 at 12:01:59 PM GMT+1 * · permalink

http://ashutoshpg.blogspot.fr/2017/12/partition-wise-joins-divide-and-conquer.html

Getting more Information about Partitions

PostgreSQL · partionning

December 19, 2017 at 12:01:12 PM GMT+1 * · permalink

http://paquier.xyz/postgresql-2/partition-information/

Robert Haas: MVCC and VACUUM

PostgreSQL · Internal · MVCC · Vacuum

December 19, 2017 at 12:00:52 PM GMT+1 * · permalink

http://rhaas.blogspot.fr/2017/12/mvcc-and-vacuum.html

PGConf EU: HyperLogLog, Eclipse, and Distributed Postgres

PostgreSQL · Hyperloglog

December 18, 2017 at 5:11:35 PM GMT+1 * · permalink

https://www.citusdata.com/blog/2017/12/11/pg-conf-eu-talks-by-citus/

Indexing with Postgres: When Less is More – PlanGrid Technology – Medium

PostgreSQL · SQL

December 16, 2017 at 1:04:14 PM GMT+1 * · permalink

https://medium.com/plangrid-technology/indexing-with-postgres-when-less-is-more-7337d6f09048

Trying to Represent a Tree Structure Using Postgres - Pat Shaughnessy

PostgreSQL · SQL · tree · LTREE · GiST

December 12, 2017 at 3:55:31 PM GMT+1 * · permalink

http://patshaughnessy.net/2017/12/11/trying-to-represent-a-tree-structure-using-postgres