Anayrat links

PostgreSQL 10 Beta vs PostgreSQL 9.6 Analytics Performance

PostgreSQL · v10

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

http://www.cybertec.at/a-quick-check-on-postgres-10-beta-analytics-performance-vs-version-9-6/

Postgres Row Level Locks | malisper.me

SQL · PostgreSQL · Isolation

June 21, 2017 at 1:36:52 PM GMT+2 * · permalink

http://malisper.me/postgres-row-level-locks/

Postgres Transaction Isolation Levels | malisper.me

SQL · PostgreSQL · Isolation

June 21, 2017 at 1:36:36 PM GMT+2 * · permalink

http://malisper.me/postgres-transaction-isolation-levels/

What is the deal with NULLs? | Experimental Thoughts

SQL

June 21, 2017 at 1:36:03 PM GMT+2 * · permalink

http://thoughts.davisjeff.com/2009/08/02/what-is-the-deal-with-nulls/

Traqueur : cas d’utilisation avancé

PostgreSQL · Statistics

June 21, 2017 at 1:35:41 PM GMT+2 * · permalink

http://pgphil.ovh/traqueur_10_04.php

SQL and Business Logic

SQL · PostgreSQL

June 19, 2017 at 6:39:22 PM GMT+2 * · permalink

http://tapoueh.org/blog/2017/06/sql-and-business-logic/

Postgres Transactions Aren’t Fully Isolated | malisper.me

PostgreSQL · SQL · Isolation

June 19, 2017 at 9:21:50 AM GMT+2 * · permalink

http://malisper.me/postgres-transactions-arent-fully-isolated/

PG Phriday: Postgres on Tap | Testing with pgTAP

PostgreSQL · Extension

June 16, 2017 at 7:46:55 PM GMT+2 * · permalink

https://blog.2ndquadrant.com/pg-phriday-postgres-tap/

Postgres Window Functions | malisper.me

PostgreSQL · SQL · Window_function

June 16, 2017 at 2:55:58 PM GMT+2 * · permalink

http://malisper.me/postgres-window-functions/

eVOL Monkey: PostgreSQL on ZFS with BPF tracing on top.

PostgreSQL · benchmark · ZFS · BPF · perf

June 16, 2017 at 2:54:21 PM GMT+2 * · permalink

http://evol-monkey.blogspot.fr/2017/06/postgresql-on-zfs-with-bpf-tracing-on.html

SELECT DISTINCT ON … ORDER BY | malisper.me

PostgreSQL · SQL

June 15, 2017 at 9:06:57 AM GMT+2 * · permalink

http://malisper.me/select-distinct-on-order-by/

TPC-H Analyzed: Hidden Messages and Lessons Learned from an Influential Benchmark

Publication · not_read · SQL · TPC · benchmark

June 14, 2017 at 9:15:34 AM GMT+2 * · permalink

https://ir.cwi.nl/pub/21424

Exploring a Data Set in SQL

PostgreSQL · SQL

June 13, 2017 at 9:07:06 PM GMT+2 * · permalink

http://tapoueh.org/blog/2017/06/exploring-a-data-set-in-sql/

Postgres Lateral Joins | malisper.me

PostgreSQL · SQL

June 13, 2017 at 9:06:50 PM GMT+2 * · permalink

http://malisper.me/postgres-lateral-joins/

Le piratage de TV5 Monde vu de l’intérieur

Security

June 11, 2017 at 7:32:56 PM GMT+2 * · permalink

http://www.lemonde.fr/pixels/article/2017/06/10/le-piratage-de-tv5-monde-vu-de-l-interieur_5142046_4408996.html

Log-structured storage - Julia Evans

SQL

June 11, 2017 at 7:32:40 PM GMT+2 * · permalink

https://jvns.ca/blog/2017/06/11/log-structured-storage/

eVOL Monkey: An unusual upgrade

PostgreSQL · Upgrade · pglogical

June 11, 2017 at 11:05:42 AM GMT+2 * · permalink

http://evol-monkey.blogspot.fr/2017/06/an-unusual-upgrade.html

[Kernel] Interruptions et tasklets « Christophe Blaess

linux · Kernel

June 10, 2017 at 8:43:03 AM GMT+2 * · permalink

https://www.blaess.fr/christophe/2017/06/06/kernel-interruptions-et-tasklets/

Bruce Momjian: Double Buffering Blues

PostgreSQL · Internal

June 10, 2017 at 8:42:36 AM GMT+2 * · permalink

https://momjian.us/main/blogs/pgblog/2017.html#June_5_2017

Recherche globale dans une base

PostgreSQL · SQL · plpgsql

June 10, 2017 at 8:41:50 AM GMT+2 * · permalink

http://blog-postgresql.verite.pro/2017/06/06/global-search.html