Anayrat links

MySQL 8.0: Query Optimizer Takes Data Buffering into Account | MySQL Server Blog

MySQL · optimizer

December 10, 2017 at 7:11:29 PM GMT+1 * · permalink

https://mysqlserverteam.com/mysql-8-0-query-optimizer-takes-data-buffering-into-account/

Adding a NOT NULL CONSTRAINT on PG Faster with Minimal Locking

PostgreSQL · SQL · constraint

December 4, 2017 at 10:14:59 PM GMT+1 * · permalink

https://medium.com/doctolib-engineering/adding-a-not-null-constraint-on-pg-faster-with-minimal-locking-38b2c00c4d1c

Ansible - Defining Variables As Dictionaries - EverythingShouldBeVirtual

ansible

December 1, 2017 at 2:24:50 PM GMT+1 * · permalink

https://everythingshouldbevirtual.com/automation/ansible-defining-variables-as-dictionaries/

Simple Data Modeling with a Test Data Set

SQL · PostgreSQL

November 30, 2017 at 9:45:50 AM GMT+1 * · permalink

http://tapoueh.org/blog/2017/11/simple-data-modeling-with-a-test-data-set/

http://shiroyasha.io/transaction-isolation-levels-in-postgresql.html

PostgreSQL · Isolation

November 27, 2017 at 2:54:35 PM GMT+1 * · permalink

http://shiroyasha.io/transaction-isolation-levels-in-postgresql.html

Peter Geoghegan's blog: pg_hexedit: Rich hex editor annotations for Postgres relfiles

PostgreSQL · Internal · index · pg_hexedit

November 27, 2017 at 9:18:47 AM GMT+1 * · permalink

http://pgeoghegan.blogspot.fr/2017/11/pghexedit-rich-hex-editor-annotations.html

Free json datasets - ...

JSON · PostgreSQL

November 22, 2017 at 9:45:31 PM GMT+1 * · permalink

https://obartunov.livejournal.com/197243.html

pspg, un pager dédié à psql

PostgreSQL

November 21, 2017 at 4:04:10 PM GMT+1 * · permalink

http://blog-postgresql.verite.pro/2017/11/21/test-pspg.html

Un peu de customisation de système avec systemd

linux · System

November 19, 2017 at 4:02:24 PM GMT+1 * · permalink

https://medspx.fr/blog/Sysadmin/customisation_systemd/

Scaling Postgres with Read Replicas & Using WAL to Counter Stale Reads — Brandur Leach

PostgreSQL · Replication

November 18, 2017 at 4:47:55 PM GMT+1 * · permalink

https://brandur.org/postgres-reads

Advisory Locks and How to Use Them - Shiroyasha

PostgreSQL · lock · advisory_locks

November 16, 2017 at 4:45:28 PM GMT+1 * · permalink

http://shiroyasha.io/advisory-locks-and-how-to-use-them.html

The Mode Ordered-Set Aggregate Function

SQL · PostgreSQL

November 16, 2017 at 4:44:48 PM GMT+1 * · permalink

http://tapoueh.org/blog/2017/11/the-mode-ordered-set-aggregate-function/

Large objects ou bytea?

PostgreSQL · Internal

November 16, 2017 at 4:44:04 PM GMT+1 * · permalink

http://blog-postgresql.verite.pro/2017/11/15/large-objects-bytea.html

select * from depesz; » Blog Archive » Waiting for PostgreSQL 11 – Add hash partitioning.

PostgreSQL · Hash · partionning

November 11, 2017 at 11:54:07 AM GMT+1 * · permalink

https://www.depesz.com/2017/11/10/waiting-for-postgresql-11-add-hash-partitioning/

Advanced SQL - window functions – Michał Konarski

PostgreSQL · SQL · Window_function

November 11, 2017 at 11:52:53 AM GMT+1 * · permalink

http://mjk.space/advanced-sql-window-functions/

How do UPSERT and MERGE work in Oracle, SQL Server, PostgreSQL and MySQL | Vlad Mihalcea's Blog

PostgreSQL · SQL · Oracle

November 9, 2017 at 4:12:51 PM GMT+1 * · permalink

https://vladmihalcea.com/2017/11/06/how-do-upsert-and-merge-work-in-oracle-sql-server-postgresql-and-mysql/

Your options for partitioning in PostgreSQL 10, explained

PostgreSQL · partionning

November 9, 2017 at 12:17:59 PM GMT+1 * · permalink

https://blog.timescale.com/scaling-partitioning-data-postgresql-10-explained-cd48a712a9a1

Parallel PostGIS IIA · Paul Ramsey

PostgreSQL · Postgis

November 9, 2017 at 12:17:08 PM GMT+1 * · permalink

http://blog.cleverelephant.ca/2017/11/parallel-postgis-2A.html

How to Avoid Excessive Sorts in Window Functions – Java, SQL and jOOQ.

PostgreSQL · SQL · Window_function

November 9, 2017 at 12:13:27 PM GMT+1 * · permalink

https://blog.jooq.org/2017/11/06/how-to-avoid-excessive-sorts-in-window-functions/

Faster bulk loading in Postgres with copy

PostgreSQL · SQL · Performance

November 9, 2017 at 12:12:14 PM GMT+1 * · permalink

https://www.citusdata.com/blog/2017/11/08/faster-bulk-loading-in-postgresql-with-copy/