Michael Paquier - PostgreSQL committer

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

Postgres 9.5 feature highlight - New missing_ok option for file access functions

2015-07-05 12:44:33 +0000

Finding its origin as a fix for [pg_rewind] (https://www.postgresql.org/docs/devel/static/app-pgrewind.html) where rewind process could fail if a file marked as listed in the source server was removed before fetching its data (see more details here, this could impact temporary files or relation file for example), here is a small feature of PostgreSQL 9.5 that may be useful for application developers:

Read more...

Postgres 9.5 feature highlight - New JSONB functions and operators

2015-06-28 13:53:44 +0000

jsonb is coming up with a set of new features in Postgres 9.5. Most of them have been introduced by the following commit:

Read more...

Postgres 9.5 feature highlight - archive_mode = always

2015-06-19 07:28:11 +0000

After seeing an email on [pgsql-general] (https://www.postgresql.org/message-id/CANkGpBs7qgAkgQ-OPZY0EsaM6+WUE5MgpyeHCGo_eOQ7tJVyyg@mail.gmail.com) about a user willing to be able to archive WAL from a standby to store them locally and to save bandwidth by only receiving the WAL segments through a WAL stream, let’s talk about a new feature of Postgres 9.5 that will introduce exactly what this user was looking for, as known as being able to archive WAL from a standby to have more complicated archiving strategies. This feature has been introduced by this commit:

Read more...

Postgres 9.5 feature highlight - pg_stat_ssl, information about SSL connections

2015-06-07 11:52:22 +0000

Today’s highlight is about a new system view that will land in Postgres 9.5, that has been introduced by this commit:

Read more...

Postgres 9.5 feature highlight - Archiving of last segment on timeline after promotion

2015-05-28 08:06:45 +0000

Postgres 9.5 is bringing a change in the way WAL is archived with the following commit:

Read more...

Postgres 9.5 feature highlight - Tracking parameters waiting for server restart

2015-05-20 03:05:12 +0000

A couple of days back the following commit has landed in the Postgres world, for the upcoming 9.5 release:

Read more...

Postgres 9.5 feature highlight - Upsert

2015-05-11 08:05:27 +0000

Marked as the number #1 wanted feature in Postgres that has been missing for years by many people, upsert support has landed in the Postgres world and will be released with the upcoming 9.5:

Read more...

Postgres utilities and restricted tokens on Windows

2015-05-01 13:25:33 +0000

On Unix-Linux platforms, Postgres binaries are not authorized to run as root use for security reasons when those utilities directly manipulate files in the data directory. See for example initdb:

Read more...

Postgres 9.5 feature highlight - palloc_extended for NULL result on OOM

2015-04-21 13:37:33 +0000

Similarly to the post of a couple of weeks back relating about the [new memory allocation routine] (/postgresql-2/postgres-9-5-feature-highlight-allocation-routine-no-oom/) able to give a plan B route in case of OOM, here is a follow-up commit adding more infrastructure in the same area but this time for some widely-used memory allocation routines:

Read more...

Postgres 9.5 feature highlight - log_autovacuum_min_duration at relation level

2015-04-14 13:18:46 +0000

[log_autovacuum_min_duration] (https://www.postgresql.org/docs/devel/static/runtime-config-autovacuum.html#GUC-LOG-AUTOVACUUM-MIN-DURATION) is a system-wide parameter controlling a threshold from which autovacuum activity is logged in the system logs. Every person who has already worked on looking at a system where a given set of table is bloated has for sure already been annoyed by the fact that even a high value of log_autovacuum_min_duration offers no guarantee in reducing log spams of not-much-bloated tables whose autovacuum runtime takes more than the threshold value, making its activity being logged (and this is after working on such a lambda system that the author of this feature wrote a patch for it). Postgres 9.5 is coming with a new feature allowing to control this logging threshold at relation level, feature introduced by this commit:

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.