Additional PostgreSQL stores

[zloster]

For quite a while there are:

• hstore (string key, value pairs)
• JSON (since 9.2 but seems like a little half-baked, see the link below, depends on the use-cases)
• JSONB (since 9.4, best full feature integration)
• UNLOGGED SQL tables - they skip the WAL and are not safe for data in case of crash. They are automatically truncated when crash is detected - so they are quite good for temporary data.

It will be interesting to see these against MongoDB.

Introduction here: https://www.citusdata.com/blog/2016/07/14/choosing-nosql-hstore-json-jsonb/

[zloster]

I've tried to update PostgreSQL to 9.6 from the APT repository of PostgreSQL Global Development Group. The test results for the same framework were quite slower than the 9.3 from the Ubuntu 14.04 APT repository. I need to check if the configuration settings for the PostgreSQL instance were in effect - I haven't check if the actual filesystem locations are the same. The benchmark toolset is copying the configuration file to predefined directory.

[zloster]

PostgreSQL is now updated to 11.x release. There are some ups and downs in the results but nothing stands out currently.