Anayrat links

Reaching 1 billion rows / second

PostgreSQL

April 5, 2017 at 9:38:27 AM GMT+2 * · permalink

https://pgconf.ru/media/2017/04/03/20170317H1_Schonig.pdf

Adaptive query optimization in PostgreSQL

PostgreSQL

April 5, 2017 at 9:37:54 AM GMT+2 * · permalink

https://pgconf.ru/media/2017/04/03/20170317H2_O.Ivanov.pdf

Dynamic Compilation of SQL Queries in PostgreSQL Using LLVM JIT

PostgreSQL

April 5, 2017 at 9:37:26 AM GMT+2 * · permalink

https://pgconf.ru/media/2017/04/03/20170317H2_Melnik.pdf

An Illustrated History of POSTGRES(QL)

PostgreSQL

April 5, 2017 at 9:36:41 AM GMT+2 * · permalink

https://pgconf.ru/media/2017/04/03/20170316H1_Hardenberg.pdf

Distributed count(distinct) with HLL on Postgres | Citus Data

PostgreSQL · Extension

April 4, 2017 at 8:22:24 PM GMT+2 * · permalink

https://www.citusdata.com/blog/2017/04/04/distributed_count_distinct_with_postgresql/

How to query JSONB, beginner sheet cheat – Hacker Noon

PostgreSQL · JSON

April 4, 2017 at 12:53:04 PM GMT+2 * · permalink

https://hackernoon.com/how-to-query-jsonb-beginner-sheet-cheat-4da3aa5082a3

select * from depesz; » Blog Archive » Waiting for PostgreSQL 10 – Full Text Search support for json and jsonb

PostgreSQL · SQL · JSON · FTS

April 4, 2017 at 9:23:08 AM GMT+2 * · permalink

https://www.depesz.com/2017/04/04/waiting-for-postgresql-10-full-text-search-support-for-json-and-jsonb/

IT Landscape for sysadmins

April 3, 2017 at 10:05:45 PM GMT+2 * · permalink

https://sysadmin.it-landscape.info

Linux block I/O tracing

bcc · linux

April 3, 2017 at 8:43:37 PM GMT+2 * · permalink

https://www.collabora.com/news-and-blog/blog/2017/03/28/linux-block-io-tracing/

Performance analysis in Linux

perf

April 3, 2017 at 8:42:27 PM GMT+2 * · permalink

https://www.collabora.com/news-and-blog/blog/2017/03/21/performance-analysis-in-linux/

select * from depesz; » Blog Archive » Waiting for PostgreSQL 10 – Logical replication support for initial data copy

PostgreSQL · pg10 · Replication

April 3, 2017 at 8:37:12 PM GMT+2 * · permalink

https://www.depesz.com/2017/04/03/waiting-for-postgresql-10-logical-replication-support-for-initial-data-copy/

Bruce Momjian: Allowing Only One Null

PostgreSQL · SQL

April 3, 2017 at 8:36:00 PM GMT+2 * · permalink

http://momjian.us/main/blogs/pgblog/2017.html#April_3_2017

Index partiels

PostgreSQL · SQL

April 1, 2017 at 11:52:18 PM GMT+2 * · permalink

http://pgphil.ovh/partial_index_96_01.php

Django and PostgreSQL

PostgreSQL · Django · Python

March 31, 2017 at 11:05:28 PM GMT+2 * · permalink

http://thebuild.com/presentations/django-pg-pgconf.pdf

PG Phriday: Design Pattern Workshop | BonesMoses.org

PostgreSQL · SQL

March 31, 2017 at 11:05:05 PM GMT+2 * · permalink

http://bonesmoses.org/2017/03/31/pg-phriday-design-pattern-workshop/

git.postgresql.org - Full Text Search support for json and jsonb

PostgreSQL · FTS

March 31, 2017 at 11:04:27 PM GMT+2 * · permalink

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e306df7f9cd6b4433273e006df11bdc966b7079e

Art of Debugging with GDB, DDD, and Eclipse

GDB

March 31, 2017 at 2:22:02 PM GMT+2 * · permalink

https://www.nostarch.com/debugging.htm

Greg Law " Give me 15 minutes & I'll change your view of GDB"

GDB

March 31, 2017 at 2:21:43 PM GMT+2 * · permalink

https://www.youtube.com/watch?v=PorfLSr3DDI

Debugging With GDB

GDB

March 31, 2017 at 2:21:20 PM GMT+2 * · permalink

https://www.youtube.com/watch?v=bAZTd769y8E

Json in Postgres - The present and Future - ...

PostgreSQL · SQL · JSON

March 31, 2017 at 8:49:39 AM GMT+2 * · permalink

http://obartunov.livejournal.com/194537.html