Presentation about the new features of PostgreSQL 9.5 with a coverage of new things about replication and other things.
Presentation about the new features of PostgreSQL 9.4, where Postgres makes a huge step in the field of NoSQL: jsonb, background workers and logical replication.
Presentation about logical decoding and its interactions with replication. A material for advanced hackers with good Postgres skill and understanding of the internals of the server, as well as of its external protocols. Not to be put in the hands of beginners.
Presentation about custom background workers, presenting basics of this new plug-in infrastructure introduced in Postgres 9.3. Several short examples as well as a coverage of the things to do to have sane bgworkers in your production environments.
Short presentation about some new features of postgres_fdw, writable foreign tables and some basics about background workers.
Short presentation about the new features of pg_top: database activity, database I/O and database disk.
Short presentation about pg_rewind, a Postgres module able to resync an old data folder whose WAL has forked with another one, making it possible to reconnect it to an existing cluster.
Short presentation of custom background workers, new feature of PostgreSQL 2013 allowing to launch custom code loaded by core server in a separate process living with the server. A “Hello World” example is added in the presentation to show simply what this feature can do.
Tutorial about Postgres-XC presenting the basics of XC 1.0 in the following areas: architecture, configuration, planning, HA and community information. Presentation has been made in cooperation with Koichi Suzuki and Ashutosh Bapat.
Postgres-XC is a write-scalable clustering solution based on PostgreSQL and uses a synchronized multi-master architecture. Postgres-XC is designed to make a cluster of multiple nodes seen as one unique transparent database to external applications. It uses a shared-nothing architecture and provides write-scalability by distributing data among nodes of the cluster. It is under PostgreSQL license.
This presentation shows the latest highlights of Postgres-XC, focusing on release 1.0. Explanation about data distribution and node management is pretty simple and makes understand the basics about Postgres-XC. Slides are under PostgreSQL license. This presentation has been done once in Paris (1h30 of presentation, a lot of questions) and in Tokyo the same month.
Unless otherwise specified, the contents of this website are (C)Copyright Michael Paquier 2010-2025 and are licensed for use under CC BY-NC-ND 4.0.