Anayrat links

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/

HeteroDB,Inc - Product

PostgreSQL · PG-Strom

July 4, 2017 at 9:28:20 PM GMT+2 * · permalink

http://heterodb.com/index.html

select * from depesz; » Blog Archive » How to make sure there is always at least one “sub” record?

PostgreSQL · SQL

July 3, 2017 at 10:55:18 PM GMT+2 * · permalink

https://www.depesz.com/2017/07/03/how-to-make-sure-there-is-always-at-least-one-sub-record/

Playing with Unicode

PostgreSQL · SQL

July 3, 2017 at 10:55:06 PM GMT+2 * · permalink

http://tapoueh.org/blog/2017/07/playing-with-unicode/

PG Phriday: Uptown Func | Making Postgres Functions Into Tables

PostgreSQL · SQL · plpgsql

July 2, 2017 at 2:52:48 PM GMT+2 * · permalink

https://blog.2ndquadrant.com/pg-phriday-uptown-func/

Efficient rollup tables with HyperLogLog in Postgres

PostgreSQL · Performance · SQL

July 2, 2017 at 2:52:21 PM GMT+2 * · permalink

https://www.citusdata.com/blog/2017/06/30/efficient-rollup-with-hyperloglog-on-postgres/

PostgreSQL and the calendar

PostgreSQL · SQL

July 2, 2017 at 2:51:57 PM GMT+2 * · permalink

http://tapoueh.org/blog/2017/06/postgresql-and-the-calendar/

Postgres JSONB | malisper.me

PostgreSQL · JSON

July 2, 2017 at 2:51:38 PM GMT+2 * · permalink

http://malisper.me/postgres-partial-indexes/

Channel binding with OpenSSL and Postgres

PostgreSQL

July 2, 2017 at 2:51:24 PM GMT+2 * · permalink

http://paquier.xyz/postgresql-2/channel-binding-openssl/

Notes on BPF & eBPF - Julia Evans

linux · BPF · perf

July 2, 2017 at 2:50:48 PM GMT+2 * · permalink

https://jvns.ca/blog/2017/06/28/notes-on-bpf---ebpf/

The future of querying json in PostgreSQL | Climbing atop the Shoulders of Giants

PostgreSQL · SQL · JSON · Lateral

June 27, 2017 at 8:25:29 PM GMT+2 * · permalink

http://gmile.me/jsonpath/

Pavel Stehule's blog: replace_empty_string

PostgreSQL · SQL

June 27, 2017 at 8:18:16 PM GMT+2 * · permalink

http://okbob.blogspot.fr/2017/06/replaceemptystring.html

Postgres TOAST | malisper.me

PostgreSQL · Internal · toast

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

http://malisper.me/postgres-toast/

The File Layout of Postgres Tables | malisper.me

PostgreSQL · Internal · Hack

June 26, 2017 at 3:16:45 PM GMT+2 * · permalink

http://malisper.me/the-file-layout-of-postgres-tables/