Search: [PostgreSQL] - Anayrat links

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

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