Re[2]: BUG #18166: 100 Gb 18000000 records table update

Thank you very much
--
Отправлено из Mail.ru для Android суббота, 21 октября 2023г., 04:22 +03:00 от Tom Lane tgl(at)sss(dot)pgh(dot)pa(dot)us :

>PG Bug reporting form < noreply(at)postgresql(dot)org> writes:
> We tried to make a script, which sets enddate = '2022-12-31' for all
> records, having the value in «DataVip» that is not maximal. For other
> records the script set s enddate = null
> The problem is that the script is running for 6 hours, the main percentage
> of time is taken by the rebuilding of indexes.
>
>This is not a bug. However ... a common workaround for bulk updates
>like that is to drop all the table's indexes and then recreate them
>afterwards. It's often quicker than doing row-by-row index updates.
>
>regards, tom lane