Search: [PostgreSQL] - Anayrat links

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/

"Our Answer to Uber" Talk at United Dev Conf, Minsk - Alexander Korotkov's blog

PostgreSQL

April 9, 2017 at 11:30:27 AM GMT+2 * · permalink

http://akorotkov.github.io/blog/2017/04/08/uber-answer/

Robert Haas: New Features Coming in PostgreSQL 10

PostgreSQL

April 9, 2017 at 11:30:14 AM GMT+2 * · permalink

http://rhaas.blogspot.fr/2017/04/new-features-coming-in-postgresql-10.html

SQL/JSON in PostgreSQL is online now - ...

PostgreSQL · JSON

April 9, 2017 at 11:29:31 AM GMT+2 * · permalink

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

Pavel Stehule's blog: How to find unindexed foreign keys

PostgreSQL · index

April 9, 2017 at 11:29:14 AM GMT+2 * · permalink

http://okbob.blogspot.fr/2017/04/how-to-find-unindexed-foreign-keys.html

git.postgresql.org - Optimize joins when the inner relation can be proven unique.

PostgreSQL

April 9, 2017 at 11:28:49 AM GMT+2 * · permalink

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=9c7f5229ad68d7e0e4dd149e3f80257893e404d4

git.postgresql.org - Add GUCs for predicate lock promotion thresholds.

PostgreSQL

April 9, 2017 at 11:28:18 AM GMT+2 * · permalink

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=c63172d60f242ad3581c83723a5b315bbe547a0e

Data Egret: Deep dive into postgres stats: pg_stat_replication

PostgreSQL · Statistics · pg_stat_replication

April 7, 2017 at 5:46:42 PM GMT+2 * · permalink

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

PostgreSQL SQL Tricks – PostgreSQL

PostgreSQL · Tricks

April 7, 2017 at 9:31:09 AM GMT+2 * · permalink

http://postgres.cz/wiki/PostgreSQL_SQL_Tricks