Michael Paquier - PostgreSQL committer

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

Postgres 9.4 feature highlight - Indexing JSON data with jsonb data type

2014-04-06 15:36:08 +0000

PostgreSQL 9.4 is shipping with a new feature called [jsonb] (https://www.postgresql.org/docs/devel/static/datatype-json.html), which is a new data type able to store JSON data supporting GIN indexing (!). In short, this feature, one of the most important of the upcoming release, if not the most important, puts Postgres directly in good position in the field of document-oriented database systems.

Read more...

Postgres 9.4 feature highlight - Triggers on foreign tables

2014-03-28 07:21:08 +0000

PostgreSQL 9.4 is coming with more support for triggers, making them now firable on foreign tables. This feature has been introduced by the following commit:

Read more...

Postgres 9.4 feature highlight - Getting contexts of lock waits

2014-03-21 04:22:08 +0000

A new feature is showing up in PostgreSQL 9.4 allowing to get more information about transaction lock waits and their circumstances. It has been introduced by this commit:

Read more...

Postgres 9.4 feature highlight - Physical slots for replication

2014-03-12 15:35:08 +0000

Replication slots is a new feature of PostgreSQL 9.4 that has been introduced by this commit:

Read more...

Postgres 9.4 feature highlight - COPY FORCE NULL

2014-03-05 14:37:27 +0000

When using COPY, there is an option called FORCE_NOT_NULL allowing to enforce a string to be not null even if it is not quoted. Here is an example of how it works:

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.