Hi,
I think I've found what I need to know.
From techdocs.postgresql.org
>> Every you run an INSERT, UPDATE, or DELETE on an indexed table,
PostgreSQL must update all of the table's indexes to reflect the new
data (unlike some
>> RDBMSs, PostgreSQL updates indexes immediately so they never get out
of synch with the data).
Thanks
Rudi.