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.

Postgres 9.4 feature highlight - data checksum switch as a GUC parameter

2013-09-23 09:45:12 +0000

Postgres 9.3 has introduced data checksums at the data page level, using a CRC-16 algorithm for the checksum calculation.

« 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 49 Next »