Search: [PostgreSQL] - Anayrat links

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

Filtrage avant application d’une fonction d’agrégat

PostgreSQL · SQL

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

http://pgphil.ovh/filter_96_01.php

(func()).* - Hidden performance issues

PostgreSQL · Performance

April 19, 2017 at 8:17:45 PM GMT+2 * · permalink

http://www.cybertec.at/func-hidden-performance-issues/

Preprocessing Data for Spatial Analysis with PostGIS and PL/R

PostgreSQL · pl/R

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

http://info.crunchydata.com/blog/preprocessing-data-for-spatial-analysis-with-postgis-and-pl/r

When autovacuum does not vacuum |

PostgreSQL · Vacuum

April 19, 2017 at 8:16:50 PM GMT+2 * · permalink

https://blog.2ndquadrant.com/when-autovacuum-does-not-vacuum/

Spatial Analytics with PostGIS, PL/R and R

PostgreSQL · R · pl/R

April 11, 2017 at 8:14:34 PM GMT+2 * · permalink

http://info.crunchydata.com/blog/spatial-analytics-with-postgres-postgis-plr

Regular Expression Stop Words for Postgresql

PostgreSQL · FTS · Hack

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

http://no0p.github.io/postgresql/2015/01/24/postgresql-regexp-stopwords.html

Poastgres : OFFSET 0, FTW

PostgreSQL · SQL · Tricks

April 11, 2017 at 2:35:43 PM GMT+2 * · permalink

http://blog.endpoint.com/2009/04/offset-0-ftw.html

select * from depesz; » Blog Archive » Waiting for PostgreSQL 10 – Identity columns

PostgreSQL · SQL

April 11, 2017 at 11:11:48 AM GMT+2 * · permalink

https://www.depesz.com/2017/04/10/waiting-for-postgresql-10-identity-columns/

Bruce Momjian: Inside the Wal

PostgreSQL · Hack · Internal · WAL

April 11, 2017 at 11:11:01 AM GMT+2 * · permalink

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

Using the PostgreSQL TAP framework in extensions |

PostgreSQL

April 11, 2017 at 11:09:16 AM GMT+2 * · permalink

https://blog.2ndquadrant.com/using-postgresql-tap-framework-extensions/

Postgres Pro à Innopolis

Présentation intéressante de Postgres Pro lros d'un séjour à Innopolis sur le développement du moteur.

PostgreSQL · Hack

April 10, 2017 at 9:10:07 AM GMT+2 * · permalink

http://www.sai.msu.su/~megera/postgres/talks/innopolis-2017.pdf

Flattening (en) – PostgreSQL

PostgreSQL · Tricks

April 9, 2017 at 3:54:44 PM GMT+2 * · permalink

http://postgres.cz/wiki/Flattening_(en)

Automatic execution plan caching in PL/pgSQL – PostgreSQL

PostgreSQL · plpgsql

April 9, 2017 at 3:54:23 PM GMT+2 * · permalink

http://postgres.cz/wiki/Automatic_execution_plan_caching_in_PL/pgSQL

Write a PL/pgSQL debugger alias advanced techniques of programming in PostgreSQL – PostgreSQL

PostgreSQL · plpgsql

April 9, 2017 at 3:54:10 PM GMT+2 * · permalink

http://postgres.cz/wiki/Write_a_PL/pgSQL_debugger_alias_advanced_techniques_of_programming_in_PostgreSQL

Profilage de fonctions PL/PgSQL

Partie 2 : http://www.loxodata.com/post/plpgsql-profiler2/

plpgsql · PostgreSQL

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

https://www.loxodata.com/post/plpgsql-profiler/