Home > mailing lists

Re: Analyze + Index - Mailing list pgsql-sql

From	Rudi Starcevic
Subject	Re: Analyze + Index
Date	November 29, 2002 02:45:38
Msg-id	3DE6F0D7.1060700@oasis.net.au Whole thread Raw
In response to	Analyze + Index (Rudi Starcevic <rudi@oasis.net.au>)
Responses	Re: Analyze + Index (Richard Huxton <dev@archonet.com>)
List	pgsql-sql

Tree view

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.

pgsql-sql by date:

From: Rudi Starcevic
Date: 29 November 2002, 02:05:36
Subject: Analyze + Index

From: Christoph Haller
Date: 29 November 2002, 07:55:26
Subject: Re: Big query problem

Re: Analyze + Index - Mailing list pgsql-sql

Previous

Next