Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id D6163632AF8 for ; Mon, 2 Aug 2010 09:36:07 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 09629-07 for ; Mon, 2 Aug 2010 12:35:59 +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 70F006323E9 for ; Mon, 2 Aug 2010 09:36:00 -0300 (ADT) Received: by mail.sdb.it (Postfix, from userid 500) id E55378115; Mon, 2 Aug 2010 14:35:57 +0200 (CEST) Received: from geronimo.sdb.it (geronimo.sdb.it [10.101.1.20]) by mail.sdb.it (Postfix) with ESMTP id E039B80B4 for ; Mon, 2 Aug 2010 14:35:57 +0200 (CEST) Received: from mailtech.sdb.it (sdbit-srv01.sdb.it [10.118.122.250]) by geronimo.sdb.it (Postfix) with ESMTP id 4C4AD3808A8 for ; Mon, 2 Aug 2010 14:35:48 +0200 (CEST) Received: from [10.118.101.88] (silviob.sdb.it [10.118.101.88]) by mailtech.sdb.it (Postfix) with ESMTP id C7E1758ABA for ; Mon, 2 Aug 2010 14:35:57 +0200 (CEST) Message-ID: <4C56BB6D.2050108@tech.sdb.it> Date: Mon, 02 Aug 2010 14:34:53 +0200 From: Silvio Brandani User-Agent: Thunderbird 2.0.0.24 (Windows/20100228) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: performance problems on Delete Content-Type: text/plain; charset=ISO-8859-15; 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.79 tagged_above=-10 required=5 tests=BAYES_50=0.8, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201008/8 X-Sequence-Number: 35257 Hi alls, we have a performance issue on deleting data from a table. the delete is on the index key so should be very fast but the table have 13 contraints of type foreign keys and the slowness seems due to all the works done with the constraint. Trying to drop the constraint and execute the delete the result is immediate. Is there a way to speed up this type of operations?? Any suggestion higly appreciated Silvio --- 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/news/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/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. --