Anayrat links

Range Types & Recursion: How to Search Availability with PostgreSQL

PostgreSQL · sql · range · CTE · RECURSIVE · not_read

February 22, 2018 at 7:22:39 PM GMT+1 * · permalink

http://info.crunchydata.com/blog/range-types-recursion-how-to-search-availability-with-postgresql

Memory-Efficient Hash Joins

Hash · Join · not_read

February 21, 2018 at 1:58:17 PM GMT+1 * · permalink

http://www.vldb.org/pvldb/vol8/p353-barber.pdf

PostgreSQL Flexible Full Text Search

FTS · PostgreSQL

February 21, 2018 at 11:36:59 AM GMT+1 * · permalink

https://asp437.github.io/posts/flexible-fts.html

The Internals of PostgreSQL : Chapter 3 Query Processing

PostgreSQL · Internal

February 20, 2018 at 10:00:52 AM GMT+1 * · permalink

http://www.interdb.jp/pg/pgsql03.html

Adaptive Execution of Compiled Queries

PostgreSQL · LLVM · JIT · not_read

February 20, 2018 at 9:31:28 AM GMT+1 * · permalink

https://db.in.tum.de/~leis/papers/adaptiveexecution.pdf?lang=en

PostgreSQL performance: How the optimizer handles views

PostgreSQL · view · sql

February 19, 2018 at 3:18:13 PM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/postgresql-performance-how-the-optimizer-handles-views/

Performance issues with ORed conditions | The Rhodium Toad

PostgreSQL · optimizer · SQL · Join · Performance

February 18, 2018 at 11:05:20 AM GMT+1 * · permalink

http://blog.rhodiumtoad.org.uk/2017/01/22/performance-issues-with-ored-conditions/

Jointures complexes, opérateurs ensemblistes

PostgreSQL · SQL · Join · CTE

February 17, 2018 at 10:26:13 AM GMT+1 * · permalink

http://pgphil.ovh/join_or_union_10_01.php

Dix choses faisable qu'avec GDB

GDB

February 16, 2018 at 8:58:55 PM GMT+1 * · permalink

http://devarea.developpez.com/dix-choses-faisables-avec-GDB/

PostgreSQL 11 - Server-side Procedures (Part 2) |

PostgreSQL · plpgsql

February 16, 2018 at 12:59:22 PM GMT+1 * · permalink

https://blog.2ndquadrant.com/postgresql-11-server-side-procedures-part-2/

GitHub - gavinwahl/postgres-json-schema: JSON Schema validation for PostgreSQL

PostgreSQL · JSON

February 14, 2018 at 5:18:13 PM GMT+1 * · permalink

https://github.com/gavinwahl/postgres-json-schema

select * from depesz; » Blog Archive » Waiting for PostgreSQL 11 – Support all SQL:2011 options for window frame clauses.

PostgreSQL · Window_function · SQL

February 13, 2018 at 3:32:34 PM GMT+1 * · permalink

https://www.depesz.com/2018/02/13/waiting-for-postgresql-11-support-all-sql2011-options-for-window-frame-clauses/

select * from depesz; » Blog Archive » Waiting for PostgreSQL 11 – Support parallel btree index builds.

PostgreSQL · index

February 12, 2018 at 6:33:06 PM GMT+1 * · permalink

https://www.depesz.com/2018/02/12/waiting-for-postgresql-11-support-parallel-btree-index-builds/

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