Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 3460D475AEC
	for <pgsql-sql@postgresql.org>; Thu, 28 Nov 2002 23:45:37 -0500 (EST)
Received: from water.oasis.net.au (water.oasis.net.au [210.8.139.2])
	by postgresql.org (Postfix) with ESMTP id B8A7B475AE6
	for <pgsql-sql@postgresql.org>; Thu, 28 Nov 2002 23:45:35 -0500 (EST)
Received: from oasis.net.au (guardian [210.8.139.5])
	by water.oasis.net.au (8.9.3/100.1) with ESMTP id PAA26439
	for <pgsql-sql@postgresql.org>; Fri, 29 Nov 2002 15:23:25 +1000
X-Authentication-Warning: water.oasis.net.au: Host guardian [210.8.139.5]
	claimed to be oasis.net.au
Message-ID: <3DE6F0D7.1060700@oasis.net.au>
Date: Fri, 29 Nov 2002 14:45:11 +1000
From: Rudi Starcevic <rudi@oasis.net.au>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.1) Gecko/20020826
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: Analyze + Index
References: <3DE6E741.3010406@oasis.net.au>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200211/430
X-Sequence-Number: 10572

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.