are there any method that "Update" command not affect other unrelated indices?

Поиск
Список
Период
Сортировка
От sunpeng
Тема are there any method that "Update" command not affect other unrelated indices?
Дата
Msg-id AANLkTi=zhUeL=2N_m=E-dR+hzAmVK6PcvxwgR7Y1rf3+@mail.gmail.com
обсуждение исходный текст
Ответы Re: are there any method that "Update" command not affect other unrelated indices?  (Ben Carbery <ben.carbery@gmail.com>)
Re: are there any method that "Update" command not affect other unrelated indices?  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
Re: are there any method that "Update" command not affect other unrelated indices?  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
Список pgsql-general
Hi, I have the following table:
CREATE TABLE A
(
   a1 integer not null,
   a2 integer,
   a3 integer,
   a4 integer
)
and have the following four indices:
create index ind_a1 on A USING gist(a1);
create index ind_a2 on A USING gist(a2);
create index ind_a3 on A USING gist(a3);
create index ind_a4 on A USING gist(a4);

now we have 10,000 update command executions using spi_exeplan():
SPI_prepare(); // prepare the plan for "update A set a4 = $1;"
for(i=0;i<10000;i++ ){
   SPI_execute_plan();//   update A set a4 = i; 
}

the question is why all four indices updated in the execution of SPI_execute_plan()? 
I think there should only one index, that is ind_a4 be updated, how to avoid other three indices updated?
thanks!

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Text search parser's treatment of URLs and emails
Следующее
От: Ben Carbery
Дата:
Сообщение: Re: are there any method that "Update" command not affect other unrelated indices?