Michael Paquier - PostgreSQL committer

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

Automatic shutdown of postmaster in case of incorrect lock file

2015-10-09 07:15:53 +0000

Just to make people aware of it, the following commit has reached the Postgres land a couple of days ago in all the active branches of the project, down to 9.1:

Read more...

Detection of COMMIT queries stuck because of synchronous replication in Postgres

2015-09-30 04:10:43 +0000

Since its introduction in 9.1, [synchronous replication] (https://www.postgresql.org/docs/devel/static/warm-standby.html#SYNCHRONOUS-REPLICATION), or the ability to wait for a WAL flush confirmation from a standby before committing a transaction on the master node (depends on synchronous_commit whose default value is on), ensuring that the transaction committed has not been lost on the standby should a failover need to be done, has faced a wide adoption in many production environments for applications that need a no-data-loss scenario. Still, such application or clients may have seen something like that:

Read more...

Postgres 9.6 feature highlight - Lock names with trace_lwlocks

2015-09-13 12:07:11 +0000

Today, here is some highlight about a small feature that will available in Postgres 9.6, useful for application and monitoring purposes:

Read more...

Postgres extension to retrieve file system information

2015-09-05 14:02:22 +0000

The set of [file access functions] (https://www.postgresql.org/docs/devel/static/functions-admin.html#FUNCTIONS-ADMIN-GENFILE) already present in PostgreSQL offer no direct possibility to retrieve file system information, giving for example no coverage of how a file system is behaving while running a given PostgreSQL instance. Modern platforms offer usually the Posix system call statvfs, that allows to retrieve this information. However, there is no direct equivalent on Windows, making the chance to have an in-core feature available depend on what are the equivalent things available statvfs for Windows, which may become ugly because this would require at quick glance the use of multiple low-level functions like for example GetDiskFreeSpaceExW to get the amount of free space available in a given path. At least that would be less elegant than calling simply statvfs.

Read more...

Postgres 9.6 feature highlight - Lock reductions for ALTER TABLE SET

2015-08-24 14:06:56 +0000

ALTER TABLE has been known for many years in the Postgres ecosystem as being a command taking systematically an ACCESS EXCLUSIVE lock on the relation being modified, preventing all operations on the relation in parallel. Those locks are getting more and more relaxed, with for example in Postgres 9.4 the following commands that got improvements:

Read more...

Postgres 9.6 feature highlight - Replication slot improvements

2015-08-14 07:15:11 +0000

Today here are highlights about new features regarding replication slots that have been lately committed and will be present as part of PostgreSQL 9.6:

Read more...

WAL reader facility

2015-08-10 07:35:44 +0000

Since PostgreSQL 9.3, the code tree is shipping a file named xlogreader.c that contains a set of independent routines that can be used to read and decode WAL records. While it is not available in an independent library, any frontend or backend application can use it at compilation to be able to work on WAL. The code of PostgreSQL uses it already in a couple of places, hence many examples are already available in core to help the development of plugins with this facility:

Read more...

Postgres 9.6 feature highlight - pg_basebackup and replication slots

2015-07-31 13:55:22 +0000

As the first post dedicated to the feature coverage of Postgres 9.6 which is currently in active development, let’s talk about the following commit:

Read more...

Minimalistic Docker container with Postgres

2015-07-24 05:24:38 +0000

Docker is well-known, is used everywhere, is used by everybody and is a nice piece of technology, there is nothing to say about that.

Read more...

Postgres 9.5 feature highlight - pg_file_settings to finely track system configuration

2015-07-15 07:47:33 +0000

PostgreSQL 9.5 is coming up with a new feature aimed at simplifying tracking of GUC parameters when those are set in a multiple set of files by introducing a new system view called pg_file_settings:

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.