Hash Indexes on Postgres

If you ever looked at the Postgres documentation on index types you must have seen the prominent box screaming caution when you get to the hash type section. Hash indexes are currently discouraged for not being WAL-logged. As the documentation says, this means, that in case of a crash, the…

UPSERT on Postgres 9.5

Postgres 9.5 RC1 was launched very recently (18th December 2015). So it's time to take some of the new features for a test drive. The one that really caught my attention for some time is UPSERT. This basically allows you to perform an action like "create or update" in…