Michael Paquier - PostgreSQL committer

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

About regression tests with Postgres plug-in modules

2013-12-09 04:01:32 +0000

PostgreSQL is made to be pluggable. With many types of plug-in structures available directly in core that make the development of external tools or even modules that can be directly be uploaded in a server with an untouched core code, there are many ways for a developer to develop a solution with things like hooks, foreign data wrappers, background workers, custom data types, (index) operators, functions, aggregates that can be loaded through extensions or defined as they are.

Read more...

Postgres 9.4: Be aware of behavior modification for SET and ABORT/ROLLBACK

2013-11-29 03:24:29 +0000

Here is something to be aware of if you have a couple of scripts relying on this behavior: ROLLBACK, ABORT and SET behavior have been changed in PostgreSQL 9.4. The modification has been introduced by this commit:

Read more...

Postgres 9.4 feature highlight - TABLE for multiple functions and multi-argument unnest()

2013-11-25 04:02:12 +0000

A new feature making possible to specify multiple functions with TABLE inside a FROM clause has made its way in Postgres. The same commit adds support for unnest with multiple arguments as well.

Read more...

Postgres 9.3 feature highlight - COPY TO/FROM PROGRAM

2013-11-18 04:27:43 +0000

Postgres 9.3 brings a new option for COPY allowing to pipe data with an external program, both in input and output. This feature has been added in the following commit:

Read more...

Measuring cascading replication lag in Postgres

2013-11-07 07:54:18 +0000

Based on the scripts developed in a previous post where a couple of hundred of Postgres servers were linked with replication cascading, let’s now have a look at the lag that cascading nodes have when creating several database objects.

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 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 Next »

Search

Social

Github

Mastodon

Twitter

RSS Feeds

Main

Postgres

Sponsor

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