Re: Batch update million records in prd DB

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Yi Sun <yinan81(at)gmail(dot)com>
Cc: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Batch update million records in prd DB
Date: 2021-02-24 15:47:35
Message-ID: CAHOFxGp2C5tM0A9xrg3cc-Towfj-3gZrEFmZXOSSbcFcpYpz6g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Of course it will impact a system using that table, but not significant I
expect and the production system should handle it. If you are committing
like this, then you can kill the script at any time and not lose any work.
The query to find the next IDs to update is probably the slowest part of
this depending on what indexes you have.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul van der Linden 2021-02-24 20:15:20 Re: Slow index creation
Previous Message Atul Kumar 2021-02-24 14:16:51 Re: getting tables list of other schema too