title: How to Update a single column in postgres in a batch for 55 Million records
body: <p>I want to update a column of postgres table. Records are around 55 Million so we need to update it in a batch of 10000 records.
  Note: we want to update all rows. But we don't want to lock our table.</p>
  <p>I am trying below query -</p>
  <pre><code>Update account set name = Some name where id between 1 and 10000
  </code></pre>
  <p>How we can make a loop for every 10000 records update?</p>
  <p>Any suggestions and help will be appreciated.</p>
  <p><strong>PostgreSQL 10.5</strong></p>