O'Reilly Tags

Batch Updates with PL/pgSQL(2 tags)Loops are slow, algorithmically speaking. Every time you find yourself looping over data, you have a process that, at best, scales linearly with the number of items to process. SQL gives you options to perform multiple updates at once; David Wheeler demonstrates how to make them work with PL/pgSQL.