Anayrat links

Advanced SQL window function quiz

Window_function · SQL · PostgreSQL

February 8, 2018 at 10:03:28 AM GMT+1 * · permalink

http://www.windowfunctions.com/

Find the number of the longest continuously rising days for a stock

PostgreSQL · CTE · Window_function · Lateral · SQL

February 7, 2018 at 3:47:42 PM GMT+1 * · permalink

http://tapoueh.org/blog/2018/02/find-the-number-of-the-longest-continuously-rising-days-for-a-stock/

Speeding up LIKE '%text%' queries (at least in PostgeSQL)

PostgreSQL · trgm · FTS

February 7, 2018 at 2:53:08 PM GMT+1 * · permalink

http://0x80.pl/articles/sql-ngram-index.html

Improving generalized inverted index lock wait times

GIN · index · not_read

February 6, 2018 at 6:39:01 PM GMT+1 * · permalink

http://iopscience.iop.org/article/10.1088/1742-6596/944/1/012022/meta

THE RD-TREE: AN INDEX STRUCTURE FOR SETS

RD-Tree · tree · index · PostgreSQL · Hack · not_read

February 6, 2018 at 6:13:48 PM GMT+1 * · permalink

http://db.cs.berkeley.edu/papers/UW-CS-TR-1252.pdf

Introduction to Information Retrieval

FTS

February 6, 2018 at 5:38:00 PM GMT+1 * · permalink

https://nlp.stanford.edu/IR-book/

JITing PostgreSQL using LLVM

JIT · PostgreSQL · Performance

February 5, 2018 at 10:01:24 AM GMT+1 * · permalink

http://anarazel.de/talks/fosdem-2018-02-03/jit.pdf

GitHub - ossc-db/pg_store_plans: Store execution plans like pg_stat_statements does for queries.

pg_store_plans · PostgreSQL · optimizer

February 5, 2018 at 10:00:14 AM GMT+1 * · permalink

https://github.com/ossc-db/pg_store_plans

GitHub - ossc-db/pg_dbms_stats: Let PostgreSQL to make execution plans using frozen statistics.

pg_dbms_stats · PostgreSQL · Statistics

February 5, 2018 at 9:59:47 AM GMT+1 * · permalink

https://github.com/ossc-db/pg_dbms_stats

PostgreSQL + Kubernetes - Zalando

PostgreSQL · Kubernetes · HA · Container · Patroni

February 5, 2018 at 9:59:02 AM GMT+1 * · permalink

https://www.postgresql.eu/events/fosdem2018/sessions/session/1735/slides/59/FOSDEM%202018_%20Blue_Elephant_On_Demand.pdf

Experiences with running PostgreSQL on Kubernetes

PostgreSQL · Kubernetes · Container · HA

February 5, 2018 at 9:58:24 AM GMT+1 * · permalink

https://gravitational.com/blog/running-postgresql-on-kubernetes/

PostgreSQL notes: Use lateral joins to run loops in a single query

PostgreSQL · SQL · Lateral

February 5, 2018 at 9:50:38 AM GMT+1 * · permalink

https://tech.npras.in/postgres-lateral-join/

Contention-Aware Lock Scheduling for Transactional Databases

MySQL · PostgreSQL · lock · Performance · Publication

February 1, 2018 at 5:50:41 PM GMT+1 * · permalink

http://www.vldb.org/pvldb/vol11/p648-tian.pdf

Exporting a Hierarchy in JSON: with recursive queries

PostgreSQL · SQL · CTE · RECURSIVE

February 1, 2018 at 8:46:53 AM GMT+1 * · permalink

http://tapoueh.org/blog/2018/01/exporting-a-hierarchy-in-json-with-recursive-queries/

Utilizing persistent memory to improve database performance & reduce costs

Performance · NVDIM

January 31, 2018 at 12:46:58 PM GMT+1 * · permalink

https://rh2017.smarteventscloud.com/connect/sessionDetail.ww?SESSION_ID=108344

Avoiding unnecessary stored procedure calls in PostgreSQL

PostgreSQL · plpgsql

January 29, 2018 at 1:45:41 PM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/avoiding-unnecessary-stored-procedure-calls-in-postgresql/

Russell Cohen | Postgres Indexes Under the Hood

PostgreSQL · index · Btree

January 28, 2018 at 6:00:45 PM GMT+1 * · permalink

https://rcoh.me/posts/postgres-indexes-under-the-hood

Principles and Applications of the Index Types Supported by PostgreSQL

PostgreSQL · index · GiST · SP-GIST · Btree · GIN · BRIN · Bloom

January 28, 2018 at 5:59:36 PM GMT+1 * · permalink

https://medium.com/@Alibaba_Cloud/principles-and-applications-of-the-index-types-supported-by-postgresql-481f59bab67d

Degree of Duplication - Simple Talk

SQL

January 25, 2018 at 6:07:58 PM GMT+1 * · permalink

https://www.red-gate.com/simple-talk/opinion/opinion-pieces/degree-of-duplication/

Le management participatif facteur de performance économique et sociale : A quelles conditions ? Eléments de réponse à partir du cas des Scop

SCOP

January 22, 2018 at 10:47:19 AM GMT+1 * · permalink

https://drive.google.com/a/bv.upmf-grenoble.fr/file/d/0B-knnwnYxciTRnluVEVtN2I5ZkU/view