Hey everyone, in this post we’ll see how to use pg_partman to automatically create partitions: Let’s consider a scenario where in we have an events table which contains some information with the timestamp: Before we jump on to create partitioned table, let’s actually create a normal table and see how…

Hey everyone, in this post we’ll see a very simple example of how indexes can drastically improve read speeds. We will take a simple enough scenario where in we have 2 tables, student and school. CREATE TABLE public.school ( id serial, PRIMARY KEY (id), name varchar(255) ); CREATE TABLE public.student ( id serial, name varchar(255), school_id int, PRIMARY KEY…

Maintaining a list of scenarios we face with git in day to day work here and their solutions. Revert your last commit and bring back to staging: 1. If it’s not your first commit in the repository, git reset --soft HEAD^ 2. If it’s your first commit in the repository, git update-ref -d HEAD Note: It will delete all of your commits and bring back everything to staging.