Anayrat links

Logical Replication in PostgreSQL 10 |

PostgreSQL · Replication

April 28, 2017 at 7:39:30 PM GMT+2 * · permalink

https://blog.2ndquadrant.com/logical-replication-postgresql-10/

Quality Assurance in PostgreSQL (Slides) - Aleksander Alekseev's blog

PostgreSQL · Hack

April 28, 2017 at 7:38:47 PM GMT+2 * · permalink

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

A dive into spatial search algorithms – Vladimir Agafonkin – Medium

Algorithm · Postgis

April 27, 2017 at 7:13:06 PM GMT+2 * · permalink

https://medium.com/@agafonkin/a-dive-into-spatial-search-algorithms-ebd0c5e39d2a

Robert Haas: Who Contributes to PostgreSQL Development?

PostgreSQL

April 26, 2017 at 5:11:20 PM GMT+2 * · permalink

http://rhaas.blogspot.fr/2017/04/who-contributes-to-postgresql.html

Using R Analytic Functions in PostGIS

PostgreSQL · Postgis · pl/R

April 25, 2017 at 6:37:07 PM GMT+2 * · permalink

http://info.crunchydata.com/blog/r-analytic-functions-in-postgis

Why favor PostgreSQL over MariaDB / MySQL

PostgreSQL · MariaDB · MySQL

April 25, 2017 at 2:10:10 PM GMT+2 * · permalink

http://www.cybertec.at/why-favor-postgresql-over-mariadb-mysql/

Statistiques étendues

PostgreSQL · Statistics · Correlation

April 23, 2017 at 9:33:11 AM GMT+2 * · permalink

http://pgphil.ovh/extended_stats_10_devel_01.php

int4 vs int8 vs uuid vs numeric performance on bigger joins

PostgreSQL · uuid

April 21, 2017 at 7:19:11 PM GMT+2 * · permalink

http://www.cybertec.at/int4-vs-int8-vs-uuid-vs-numeric-performance-on-bigger-joins/

PG Phriday: Who Died and Made You Boss?! (The Investigatining!) | BonesMoses.org

PostgreSQL

April 21, 2017 at 7:16:15 PM GMT+2 * · permalink

http://bonesmoses.org/2017/04/21/pg-phriday-who-died-and-made-you-boss-the-investigatining/

Data Egret: Deep dive into postgres stats: pg_stat_all_tables

PostgreSQL · pg_stat_all_tables

April 21, 2017 at 9:13:25 AM GMT+2 * · permalink

http://blog.postgresql-consulting.com/2017/04/deep-dive-into-postgres-stats_20.html

How to Calculate Multiple Aggregate Functions in a Single Query – Java, SQL and jOOQ.

PostgreSQL · SQL

April 20, 2017 at 6:01:26 PM GMT+2 * · permalink

https://blog.jooq.org/2017/04/20/how-to-calculate-multiple-aggregate-functions-in-a-single-query/

Générer des données de test

PostgreSQL · SQL

April 19, 2017 at 9:25:25 PM GMT+2 * · permalink

http://pgphil.ovh/test_case_10_devel_01.php

How do PostgreSQL advisory locks work | Vlad Mihalcea's Blog

PostgreSQL

April 19, 2017 at 9:19:21 PM GMT+2 * · permalink

https://vladmihalcea.com/2017/04/12/how-do-postgresql-advisory-locks-work/

Removing duplicate rows in PostgreSQL

PostgreSQL · SQL

April 19, 2017 at 8:32:31 PM GMT+2 * · permalink

http://www.cybertec.at/removing-duplicate-rows-in-postgresql/

Slides "NoSQL Postgres" - ...

NoSQL · JSON · PostgreSQL

April 19, 2017 at 8:31:53 PM GMT+2 * · permalink

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

Bruce Momjian: Incremental File System Backup

PostgreSQL · Backup

April 19, 2017 at 8:28:26 PM GMT+2 * · permalink

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

Bruce Momjian: Switchover vs. Failover

PostgreSQL · Replication

April 19, 2017 at 8:27:00 PM GMT+2 * · permalink

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

select * from depesz; » Blog Archive » Waiting for PostgreSQL 10 – Support SCRAM-SHA-256 authentication (RFC 5802 and 7677).

PostgreSQL · Security

April 19, 2017 at 8:26:43 PM GMT+2 * · permalink

https://www.depesz.com/2017/04/18/waiting-for-postgresql-10-support-scram-sha-256-authentication-rfc-5802-and-7677/

Postgres 10 highlight - SASLprep in SCRAM-SHA-256

PostgreSQL · Security

April 19, 2017 at 8:26:08 PM GMT+2 * · permalink

http://paquier.xyz/postgresql-2/postgres-10-saslprep-scram/

Clés primaires auto-incrémentées

PostgreSQL · SQL

April 19, 2017 at 8:25:44 PM GMT+2 * · permalink

http://pgphil.ovh/pk_autoincrement_10_devel_01.php