Search: [PostgreSQL] - Anayrat links

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/

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

Using plantuner for debugging indexes in PostgreSQL - ...

plantuner · PostgreSQL · index

January 20, 2018 at 11:36:41 AM GMT+1 * · permalink

https://obartunov.livejournal.com/197604.html

Data Egret: PostgreSQL Performance Meltdown?

PostgreSQL · Performance

January 19, 2018 at 4:47:06 PM GMT+1 * · permalink

http://blog.dataegret.com/2018/01/postgresql-performance-meltdown.html

Hash Joins Past, Present & Future

Hash · PostgreSQL · Internal

January 12, 2018 at 3:24:26 PM GMT+1 * · permalink

http://www.pgcon.org/2017/schedule/attachments/455_pgcon-2017-hash-joins.pdf

Write Skew: Parallel Hash for PostgreSQL

Parallel · Performance · PostgreSQL · Hash · Join

January 10, 2018 at 12:21:20 PM GMT+1 * · permalink

http://write-skew.blogspot.fr/2018/01/parallel-hash-for-postgresql.html

Peter Geoghegan's blog: Exploring SP-GiST and BRIN indexes visually using pg_hexedit

SP-GIST · BRIN · index · PostgreSQL · Internal · pg_hexedit

January 9, 2018 at 9:33:53 AM GMT+1 * · permalink

http://pgeoghegan.blogspot.fr/2018/01/exploring-sp-gist-and-brin-indexes.html

Robert Haas: The State of VACUUM

Vacuum · PostgreSQL

January 8, 2018 at 9:04:47 PM GMT+1 * · permalink

http://rhaas.blogspot.fr/2018/01/the-state-of-vacuum.html

Streaming replication stopped? One more thing to check.

PostgreSQL · Replication

January 8, 2018 at 9:03:25 PM GMT+1 * · permalink

http://thebuild.com/blog/2017/10/27/streaming-replication-stopped-one-more-thing-to-check/

PG Phriday: Postgres on ZFS | Ways ZFS Can Make Postgres an Even Better Database

ZFS · PostgreSQL

January 8, 2018 at 9:02:45 PM GMT+1 * · permalink

https://blog.2ndquadrant.com/pg-phriday-postgres-zfs/

PostgreSQL notes: Recursive queries vs standard ORM

PostgreSQL · CTE

January 8, 2018 at 8:27:28 PM GMT+1 * · permalink

https://tech.npras.in/postgres-recursive-query/