Anayrat links

Postgres autovacuum, bloat and tpc-c style workloads – Command Prompt, Inc.

PostgreSQL · Vacuum

July 28, 2017 at 1:46:26 PM GMT+2 * · permalink

https://www.commandprompt.com/blog/postgres_autovacuum_bloat_tpc-c/

pg_dirtyread: Read dead but unvacuumed tuples from a PostgreSQL relation

PostgreSQL · Internal · Hack

July 23, 2017 at 1:36:32 PM GMT+2 * · permalink

https://github.com/ChristophBerg/pg_dirtyread

PostgreSQL: Indexes and foreign keys

Postgis · SQL

July 21, 2017 at 12:47:16 AM GMT+2 * · permalink

http://www.cybertec.at/postgresql-indexes-and-foreign-keys/

Scalable MVCC Solution for Many Core Machines - CSN

PostgreSQL · Hack · Internal

July 19, 2017 at 9:23:51 AM GMT+2 * · permalink

http://www.pgcon.org/2015/schedule/attachments/339_Scalable_MVCC_Solution_ManyCore_Machines.pdf

Peter Geoghegan's blog: PostgreSQL Index bloat under a microscope

PostgreSQL · Internal · index · Hack

July 19, 2017 at 8:50:10 AM GMT+2 * · permalink

http://pgeoghegan.blogspot.fr/2017/07/postgresql-index-bloat-microscope.html

Analytics Playbook: Log Tables – Fishtown Analytics

PostgreSQL · SQL

July 18, 2017 at 9:32:45 PM GMT+2 * · permalink

https://blog.fishtownanalytics.com/analytics-playbook-log-tables-7df0e6aacb42

SQL Data Aggregation Aggravation - Simple Talk - Joe Celko

SQL

July 17, 2017 at 9:06:28 PM GMT+2 * · permalink

https://www.red-gate.com/simple-talk/sql/t-sql-programming/sql-data-aggregation-aggravation/

Customizing My Postgres Shell

PostgreSQL · psql

July 17, 2017 at 9:02:14 PM GMT+2 * · permalink

https://www.citusdata.com/blog/2017/07/16/customizing-my-postgres-shell-using-psqlrc/

Removing duplicates in a PostgreSQL array – The Falconry – Medium

PostgreSQL · SQL

July 17, 2017 at 9:01:32 PM GMT+2 * · permalink

https://medium.com/the-falconry/removing-duplicates-in-a-postgresql-array-c972e4ed3bf0

Pavel Stehule's blog: Postgres Pager (pager designed for psql)

PostgreSQL · psql

July 17, 2017 at 8:59:59 PM GMT+2 * · permalink

http://okbob.blogspot.fr/2017/07/i-hope-so-every-who-uses-psql-uses-less.html

Setting owner at CREATE TABLE - Magnus Hagander's blog

PostgreSQL · SQL

July 17, 2017 at 8:59:43 PM GMT+2 * · permalink

https://blog.hagander.net/setting-owner-at-create-table-237/

PG Phriday: Crazy Correlated Column Crusade | Postgres 10 Correlated Statistics For Fun and Profit

PostgreSQL · Statistics

July 14, 2017 at 11:06:13 PM GMT+2 * · permalink

https://blog.2ndquadrant.com/pg-phriday-crazy-correlated-column-crusade/

Can I do it with PostgreSQL? – 15 – invisible indexes - Blog dbi services

PostgreSQL · Extension

July 14, 2017 at 4:02:07 PM GMT+2 * · permalink

https://blog.dbi-services.com/can-i-do-it-with-postgresql-15-invisible-indexes/

What are typed tables in PostgreSQL? - Blog dbi services

PostgreSQL · SQL

July 14, 2017 at 4:01:28 PM GMT+2 * · permalink

https://blog.dbi-services.com/what-are-typed-tables-in-postgresql/

Data Recovery Using pg_filedump (Slides) - Aleksander Alekseev's blog

PostgreSQL · Internal · Hack

July 11, 2017 at 10:15:42 PM GMT+2 * · permalink

https://afiskon.github.io/pgday2017-talk.html

10 Common Data Structures Explained with Videos + Exercises

Algorithm

July 10, 2017 at 9:02:55 AM GMT+2 * · permalink

https://medium.freecodecamp.org/10-common-data-structures-explained-with-videos-exercises-aaff6c06fb2b

Automating letsencrypt and haproxy | BrixIT Blog

Security · haproxy · letsencrypt

July 10, 2017 at 9:02:25 AM GMT+2 * · permalink

https://blog.brixit.nl/automating-letsencrypt-and-haproxy

Linux tracing systems & how they fit together - Julia Evans

perf · Dtrace · linux · Kernel · eBPF

July 9, 2017 at 4:13:59 PM GMT+2 * · permalink

https://jvns.ca/blog/2017/07/05/linux-tracing-systems/

hotspot - a GUI for the Linux perf profiler - KDAB

perf · flamegraph

July 6, 2017 at 10:09:01 PM GMT+2 * · permalink

https://www.kdab.com/hotspot-gui-linux-perf-profiler/

Understanding vNUMA in vSphere – The Wifi-Cable

vmware · numa

July 6, 2017 at 7:05:13 PM GMT+2 * · permalink

https://thewificable.com/2017/07/06/understanding-vnuma-in-vsphere/