Database Trigger Procedure in Postgres

An introduction to triggers in Postgres

PostGres: Update Column with Array Values

Update an Array UPDATE users SET topics = '{crows, cats}'; Append an Array UPDATE users SET topics = topics || '{cats,mice}'; Append operation creates duplicates. Reference https://makandracards.com/makandra/36097-postgresql-how-to-add-remove-modify-array-values-and-how-to-replace-1-value-with-multiple-values

Design Problems of PostGres- Part II

The problems in PostGres DB are solved in MySQL to an extent. The design merits of MySQL are the following: The primary index has a mapping of key to an offset in the disk. But all secondary index tables have a mapping of key to the primary index’s key. Primary index -------------------- | key |…

Design Problems of PostGres- Part I

This post is a quick summary of Why Uber moved from PostGres to MySQL. PostGres Rows and CTID PostGres provides transactions. Transactions need multiple versions of data. So PG is Multi Versioned DB. PG considers each row immutable. Any change to a row creates a new row version. A row is represented as an offset…

%d bloggers like this: