Postgres Updating only changed columns against entire row

Поиск
Список
Период
Сортировка
От Debraj Manna
Тема Postgres Updating only changed columns against entire row
Дата
Msg-id CAF6DVKMGLnWB4tzWduQXXR8vtyu1DFGi9nh3u++szWZJsvSPTQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Postgres Updating only changed columns against entire row  (Ron <ronljohnsonjr@gmail.com>)
Re: Postgres Updating only changed columns against entire row  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-admin

Let's say I have a table like below

CREATE TABLE empl(   id SERIAL PRIMARY KEY,   name VARCHAR NOT NULL,   address VARCHAR NOT NULL,   status int NOT NULL,   metadata varchar NOT NULL
);

and it has data like

(2, 'tuk', 'ind', 1, 'meta')
...
(200, 'tuka', 'eng', 2, 'meta2')
  1. update empl set status = 2 where (id = 2);
  2. update empl set status = 2, name='tuk', address='ind', metadata='meta' where (id = 2);

Can someone let me know if there are any advantages of doing #1 over #2 assuming there are no other indices or triggers on the table? Which is generally preferred?

Postgres Version - 10.17

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

Предыдущее
От: Ron
Дата:
Сообщение: Re: What to watch out for when ALTERing NUMERIC(38,0) to BIGINT?
Следующее
От: Ron
Дата:
Сообщение: Re: Postgres Updating only changed columns against entire row