Michael Paquier - PostgreSQL committer

  • About
  • Home
  • Manuals
  • Presentations
  • Projects
  • Resume
  • Tags

Postgres 9.6 feature highlight - Generic WAL interface

2016-05-11 06:55:34 +0000

One feature added in Postgres 9.6 is the WAL generic interface, which is a base for more fancy things like custom access methods. Note that custom access methods are quite powerful in themselves as they allow the development of for example custom index methods as external modules. The generic WAL records have been added primarily as the infrastructure to provide reliability to the custom access methods by allowing them to create WAL records. This has been introduced by the following commit:

Read more...

Postgres 9.6 feature highlight - pg_rewind and timeline switches

2016-04-25 12:45:32 +0000

pg_rewind, a utility introduced in PostgreSQL 9.5 allowing one to reconnect a master to one of its promoted standbys, making unnecessary the need of a new base backup and hence saving a huge amount of time, has gained something new in Postgres 9.6 with the following commit:

Read more...

Postgres 9.6 feature highlight - Multiple synchronous standbys

2016-04-13 00:15:34 +0000

Among the features that are going to land with Postgres 9.6, here is a nice one that is going to make users in charge of high-availability structures quite happy, in short a lot:

Read more...

Postgres 9.6 feature highlight - read balancing with remote_apply

2016-04-05 13:01:17 +0000

While the last commit fest of PostgreSQL 9.6 is moving to an end with a soon-to-come feature freeze, here is a short story about one of the features that got committed close to the end of it:

Read more...

Postgres 9.6 feature highlight - WAL receiver status via SQL

2016-01-09 13:10:22 +0000

Following the recent post related to the extension that gives a representation of a WAL receiver doing WAL recovery via streaming, here is its equivalent in-core, for a new feature that will be available in Postgres 9.6:

Read more...

Tracking WAL receiver status during replication via SQL

2015-12-11 05:35:22 +0000

In the series of extensions making the life of operators and DBAs easier, and after the facility to easy the tracking of Postgres backend processes waiting for synchronous replication, here is a new feature that has been added to the existing module pg_rep_state aimed at representing at SQL level what shared memory holds for a WAL receiver (a WAL receiver being what is used on a backend receiving WAL in replication from a root node via streaming).

Read more...

Postgres 9.6 feature highlight - COPY and DML statements

2015-12-02 12:25:45 +0000

A new set of queries that can be handled in [COPY] (https://www.postgresql.org/docs/devel/static/sql-copy.html) statement (as well as psql’s \copy) has been added in PostgreSQL 9.6 by the following commit:

Read more...

Postgres 9.6 feature highlight - operator and function pushdown with postgres_fdw

2015-11-11 03:18:22 +0000

The following commit has popped up not so long ago in the development branch of Postgres 9.6:

Read more...

pg_panic to test deployment robustness with Postgres

2015-11-06 13:02:11 +0000

PostgreSQL is a piece of software known for its robustness, being something reliable on which a complete infrastructure can be based to allow availability, reliability and performance. However, sometimes things can go wrong, there may be file-system or OS problems popping up, potentially corrupting a database and forcing one to roll in a backup or to perform a failover to another node. Sometimes, when studying the stability of a system, QE/QA procedures involve making one piece or more of an infrastructure unstable to test how other components can react to a failure and see if they can properly recover from it.

Read more...

Reliability improvements for pg_ctl start

2015-10-24 11:44:23 +0000

Just after the last set of minor versions of Postgres has been released, the following commit has popped up on all the stable branches to improve a long-time weird behavior of pg_ctl start.

Read more...

« Prev 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Next »

Search

Links

Github

Twitter

RSS Feeds

Main

Postgres

Unless otherwise specified, the contents of this website are (C)Copyright Michael Paquier 2010-2021 and are licensed for use under CC BY-SA 3.0.