Search: [PostgreSQL] - Anayrat links

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

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

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

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/