Archives par mot-clé : linux

LdS S39-2016

Minimizing tuple overhead

Safe and unsafe operations for high volume PostgreSQL

Postgres 9.6 Features


PG Phriday: Bodacious Benchmarks

PostgreSQL: nettoyer complètement un schéma sans effort

Those darn Large Objects

One more time about collation in PostgreSQL

BRIN Indexes in Postgres 9.5

Blending gene sequence variation data into PostgreSQL


Yandex.Mail success story

Installer et utiliser LXC sur Gentoo / Calculate Linux

Handling Very Large Tables in Postgres Using Partitioning

Postgres 10 highlight – recovery_target_lsn

Btrfs Finally Has A Concise Status Page

Vim 8.0 Released With GTK3 Support, Async I/O & DirectX Support

Back to the Future Pt. 1: Introduction to pg_rewind

A Tour of Postgres’ Foreign Data Wrappers

Binning functions


pg_cron: Run periodic jobs in PostgreSQL

PG Phriday: Irrelevant Inclinations

Créer et utiliser des conteneurs LXC avec l’inventaire in-memory d’Ansible

Pragma autonomous_transaction dans PostgreSQL

The „synchronous_commit“ parameter and streaming replication

Postgres 10 highlight – ShmemAlloc and ShmemAllocNoError

PG Phriday: Cult of Functionality

When To Avoid JSONB In A PostgreSQL Schema

Kernel Recipes 2016 : découvrez la 5e édition de la conférence sur le noyau Linux

Is it worth spending more money on more disks?

Les optimisations des compilateurs

My Picks for PgOpen 2016

The sizes of FTS indices

pv : comment connaître la progression d’une tâche sous GNU/Linux

Timeseries: How long can the elephant remember?

PgSQL Indexes and « LIKE »


BorgBackup, borg pour les intimes

PG Phriday: Forensic Fundamentals

Support des transactions autonomes dans PostgreSQL

Evolution of Fault Tolerance in PostgreSQL: Synchronous Commit

What is BPF and why is it taking over Linux Performance Analysis?

Btrfs RAID vs. Linux Software RAID Benchmarks On Linux 4.7

LdS S33-2016

PostgreSQL vs. Linux kernel versions

On Uber’s Choice of Databases

Uber’s move away from PostgreSQL

Difference between PostgreSQL and MySQL: (1) Replication

Why we lost Uber as a user

Thoughts on Uber’s List of Postgres Limitations

Reading a Postgres EXPLAIN ANALYZE Query Plan

Logging of data modifications and the “log_statement” configuration parameter

Get the Postgres format for an index expression

Postgres: select ‘explain’ output into a query

Lesson learnt the hard way: Postgres in Production at GoCardless

An illustration of JSONB capabilities in Postgres 9.5

Using GNU GLOBAL with PostgreSQL

Protéger sa vie privée avec l’IPv6

When to use unstructured datatypes in Postgres–Hstore vs. JSON vs. JSONB

Analyzing PostgreSQL logs using pgBadger

Inheritance – One more reason to love PostgreSQL

Exploding runtime: How nested loops can destroy speed


Your Broken PostGIS Upgrade

Linux 4.4 To 4.7 – EXT4 vs. F2FS vs. Btrfs Benchmarks

GitFlow : la méthodologie et la pratique

Workshop PostgreSQL 9.6 – 9 septembre 2016

Au programme de la Session PostgreSQL / PostGIS du jeudi 22 septembre …

PGDay UK 2016 — Performace for queries with grouping

On the benefits of sorted paths


Locating the recovery point just before a dropped table

PostgreSQL 9.6: Parallel Sequential Scan

Série d’article sur la tolérance au pannes de Postgres par Gulcin Yildirim :

Postgres 9.6 feature highlight – pg_blocking_pids

Postgres 9.6 – Upcoming changes for pg_get functions on invalid objects

PG Phriday: A Postgres Perspective on MongoDB

PG Phriday: All in a Name

PG Phriday: The Audacity of NoSQL

PG Phriday: Constipated Connections

PG Phriday: Elephantary, My Dear

PG Phriday: Inevitable Interdiction

Postgres: Explain + Notice

Speed up getting WAL files from Barman

Sharding Postgres with semi-structured data and its performance implications

Sharding a multi-tenant app with Postgres

paginators – The story about voluntary pain

LdS S06-2016

Oups raté le LDS S04 :/

Si vous voulez contribuer à la traduction de la documentation française de Postgres 9.5 c’est par là : Début de la traduction du manuel 9.5

PG Phriday: COPY and Alternative Import Methods

PG Phriday: Tackling Intractable ACLs

Waiting for 9.6 – Add trigonometric functions that work in degrees

Waiting for 9.6 – Support parallel joins, and make related improvements

Waiting for 9.6 – Add num_nulls() and num_nonnulls() to count NULL arguments.

Indexer pour rechercher des chaines courtes dans PostgreSQL

Creating a Document-Store Hybrid in Postgres 9.5

Cours de bases de données – Aspects systèmes

MultibootUSB – Pour configurer une clé USB afin de booter sur différentes distrib Linux

tmux: trucs & astuces

PostgreSQL High Availability, 2016 Edition