is single row update improved with function

Поиск
Список
Период
Сортировка
От Rob Sargent
Тема is single row update improved with function
Дата
Msg-id D64DD424-9BAD-41C5-92E2-0F5F78752B4F@gmail.com
обсуждение исходный текст
Ответы Re: is single row update improved with function  (David Rowley <david.rowley@2ndquadrant.com>)
Список pgsql-general
I must update 3M of 100M records, with tuple specific modifications.  I can generate the necessary sql, but I’m
wonderingif files of simple update statements affecting a single row is more effective than files of a function call
doingthe same update given the necessary values, including where clause restrictions?  The query plan set by the first
shouldbe decent for the remainder. 

Alternatively, would a bulk load into a table of replacement values and join info be the fastest way?

Either way I can break the updates into roughly 393 transactions (7500 rows affected per tx) or 8646 transactions (350
rows per tx) if less is more in this world. 

I’ll be the only user during this work.

OS=centos 7, 4core virtual 64G memory; pg=10.0;

В списке pgsql-general по дате отправления:

Предыдущее
От: Ibrahim Edib Kokdemir
Дата:
Сообщение: Re: invalid memory alloc request size 576460752438159360
Следующее
От: David Rowley
Дата:
Сообщение: Re: is single row update improved with function