How to update large number of records in batches in PostgreSQL

BySuresh Gadupu Database

Recently at my work added a new column to two of our database tables and the newly introduced column had to updated based on the sequence number. These tables had millions of records. Before updating records in huge numbers, we need to understand the little of PostgreSQL memory architecture. All the memory components which are…