Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id DB9731337B2F for ; Wed, 10 Nov 2010 11:57:17 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 77234-01 for ; Wed, 10 Nov 2010 15:57:10 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.sdb.it (mail.sdb.it [212.141.11.2]) by mail.postgresql.org (Postfix) with ESMTP id 4B218133798E for ; Wed, 10 Nov 2010 11:57:10 -0400 (AST) Received: by mail.sdb.it (Postfix, from userid 500) id 0572E81AF; Wed, 10 Nov 2010 16:57:10 +0100 (CET) Received: from geronimo.sdb.it (geronimo.sdb.it [10.101.1.20]) by mail.sdb.it (Postfix) with ESMTP id 00420818E; Wed, 10 Nov 2010 16:57:10 +0100 (CET) Received: from mailtech.sdb.it (sdbit-srv01.sdb.it [10.118.122.250]) by geronimo.sdb.it (Postfix) with ESMTP id C3E603808AF; Wed, 10 Nov 2010 16:56:46 +0100 (CET) Received: from [10.118.101.88] (silviob.sdb.it [10.118.101.88]) by mailtech.sdb.it (Postfix) with ESMTP id E009958ABC; Wed, 10 Nov 2010 16:57:09 +0100 (CET) Message-ID: <4CDAC0D5.3020305@tech.sdb.it> Date: Wed, 10 Nov 2010 16:57:09 +0100 From: Silvio Brandani User-Agent: Thunderbird 2.0.0.24 (Windows/20100228) MIME-Version: 1.0 To: Kevin Grittner Cc: pgsql-admin@postgresql.org Subject: Re: reindex script References: <4CDA46390200002500037500@gw.wicourts.gov> In-Reply-To: <4CDA46390200002500037500@gw.wicourts.gov> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Private-Material: Please read notice X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.011 tagged_above=-10 required=5 tests=BAYES_40=-0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201011/78 X-Sequence-Number: 36044 Kevin Grittner ha scritto: > Silvio Brandani wrote: > > >> Is it possible to use a reindex in a share lock mode ?? >> > > Check out the CONCURRENTLY keyword in CREATE INDEX: > > http://www.postgresql.org/docs/current/interactive/sql-createindex.html > > You could create a duplicate index concurrently, drop the old index, > and rename the new one to the old name. > > -Kevin > > we really need to migrate to version postges 9.x . thanks, --- Utilizziamo i dati personali che la riguardano esclusivamente per nostre finalitą amministrative e contabili, anche quando li comunichiamo a terzi. Informazioni dettagliate, anche in ordine al Suo diritto di accesso e agli altri Suoi diritti, sono riportate alla pagina http://www.savinodelbene.com/privacy.html Se avete ricevuto questo messaggio per errore Vi preghiamo di ritornarlo al mittente eliminandolo assieme agli eventuali allegati, ai sensi art. 616 codice penale http://www.savinodelbene.com/privacy/codice_penale_616.html L'Azienda non si assume alcuna responsabilitą giuridica qualora pervengano da questo indirizzo messaggi estranei all'attivitą lavorativa o contrari a norme. --