advertisement

O'Reilly Tags

We're experimenting with a folksonomy based on tag data provided by del.icio.us. Follow development in this blog post.


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.