Skip site navigation (1) Skip section navigation (2)

Re: performance problems on Delete

From: Silvio Brandani <silvio(dot)brandani(at)tech(dot)sdb(dot)it>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: performance problems on Delete
Date: 2010-08-03 11:41:50
Message-ID: 4C58007E.4010909@tech.sdb.it (view raw or flat)
Thread:
Lists: pgsql-admin
Kevin Grittner ha scritto:
> Silvio Brandani  wrote:
>  
>   
>> 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.
>>     
>  
> The usual reason for this is that you don't have indexes on the
> referencing columns, so to check whether the delete is OK it has to
> scan the related tables.  Think about what rows need to be checked to
> determine whether the delete is allowed and index the columns which
> will allow fast access to them.
>  
> -Kevin
>
>   
yes,
you where right , an index was missing.

thanks a lot

-- 

---






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.
--

In response to

pgsql-admin by date

Next:From: xsunDate: 2010-08-03 14:39:29
Subject: The function of lock file named ".s.PGSQL.<port>.lock" on Linux?
Previous:From: Tom LaneDate: 2010-08-02 14:04:01
Subject: Re: Statistics Collector not collecting server activities

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group