Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A8269475C15 for ; Fri, 29 Nov 2002 05:45:02 -0500 (EST) Received: from anchor-post-30.mail.demon.net (anchor-post-30.mail.demon.net [194.217.242.88]) by postgresql.org (Postfix) with ESMTP id 13870475AFF for ; Fri, 29 Nov 2002 05:45:01 -0500 (EST) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-30.mail.demon.net with esmtp (Exim 3.35 #1) id 18Hidq-000EEH-0U; Fri, 29 Nov 2002 10:45:02 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id 69861173E8; Fri, 29 Nov 2002 10:32:27 +0000 (GMT) Received: from client.archonet.com (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with ESMTP id D308E172A0; Fri, 29 Nov 2002 10:32:26 +0000 (GMT) Content-Type: text/plain; charset="iso-8859-1" From: Richard Huxton Organization: Archonet Ltd To: Rudi Starcevic , pgsql-sql@postgresql.org Subject: Re: Analyze + Index Date: Fri, 29 Nov 2002 10:32:26 +0000 User-Agent: KMail/1.4.3 References: <3DE6E741.3010406@oasis.net.au> <3DE6F0D7.1060700@oasis.net.au> In-Reply-To: <3DE6F0D7.1060700@oasis.net.au> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200211291032.26769.dev@archonet.com> X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/434 X-Sequence-Number: 10576 On Friday 29 Nov 2002 4:45 am, Rudi Starcevic wrote: > 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). Yep - the ANALYSE updates the statistics the planner uses. So - you should= =20 analyse when a noticable portion of your data has changed. If you had 3000= =20 users and batch inserted 1000 users you'd probably want to ANALYSE. --=20 Richard Huxton