Anayrat links

Configuring huge pages for your PostgreSQL instance, Debian version - Blog dbi services

hugepages · linux · PostgreSQL

February 26, 2018 at 9:36:25 AM GMT+1 * · permalink

https://blog.dbi-services.com/configuring-huge-pages-for-your-postgresql-instance-debian-version/

Configuring huge pages for your PostgreSQL instance, RedHat/CentOS version - Blog dbi services

hugepages · linux · PostgreSQL

February 26, 2018 at 9:35:55 AM GMT+1 * · permalink

https://blog.dbi-services.com/configuring-huge-pages-for-your-postgresql-instance-redhatcentos-version/

Fsync Performance on Storage Devices - Percona Database Performance Blog

fsync · storage · NVMe · SSD

February 26, 2018 at 9:35:27 AM GMT+1 * · permalink

https://www.percona.com/blog/2018/02/08/fsync-performance-storage-devices/

Database migrations and Pum

PostgreSQL · sql

February 23, 2018 at 2:00:16 PM GMT+1 * · permalink

http://oslandia.com/en/2018/02/23/database-migrations-and-pum/

XFS, Reflinks and Deduplication – The ongoing struggle

xfs · cow · deduplication · linux

February 23, 2018 at 12:28:02 PM GMT+1 * · permalink

http://strugglers.net/~andy/blog/2017/01/10/xfs-reflinks-and-deduplication/

When Postgres blocks: 7 tips for dealing with locks

PostgreSQL · lock · DDL · schema_migration

February 23, 2018 at 10:02:46 AM GMT+1 * · permalink

https://www.citusdata.com/blog/2018/02/22/seven-tips-for-dealing-with-postgres-locks/

Why upgrade PostgreSQL?

PostgreSQL

February 23, 2018 at 9:52:40 AM GMT+1 * · permalink

http://why-upgrade.depesz.com

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/