Postgres 9.4 feature highlight - dates with more than 5-digit years

2013-11-04 07:22:22 +0000

When managing an MMORPG server of a science-fiction game, you may have noticed that all the dates that Postgres could store were limited to 4 digits for a YMD (Year/Month/Date), HMS (Hour/Minute/Second) or a year. This behavior has been improved with the following commit:

Postgres 9.4 feature highlight - Improvement of column management for auto-updatable views

2013-10-23 02:09:09 +0000

Auto-updatable views have a new feature in Postgres 9.4 thanks to a patch allowing only a portion of columns to be updatable. Here is the commit introducing the feature:

Cascading replication in chain with 10, 100, 200 nodes?

2013-10-18 08:29:49 +0000

Cascading replication has been introduced in 9.2, but have you ever tried long chains of cascading nodes in Postgres?

And what about pg_cron with background workers?

2013-10-12 06:19:32 +0000

With the introduction of background workers in Postgres 9.3 and even the introduction of dynamic background workers, allowing to start workers while server is running, there is quite a bit of infrastructure in place to play with.