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

Re: slow deletes on pgsql 7.4

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Junaili Lie" <junaili(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: slow deletes on pgsql 7.4
Date: 2006-04-25 23:09:18
Message-ID: 9147.1146006558@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
"Junaili Lie" <junaili(at)gmail(dot)com> writes:
> we encounter issues when deleting from a table based on id (primary key). O=
> n
> certain 'id', it took forever to delete and the i/o is 100% busy.

Almost always, if delete is slow when selecting the same rows is fast,
it's because you've got a trigger performance problem --- most commonly,
there are foreign keys referencing this table from other tables and you
don't have the referencing columns indexed.

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Jim C. NasbyDate: 2006-04-25 23:55:04
Subject: Re: Large (8M) cache vs. dual-core CPUs
Previous:From: Joshua D. DrakeDate: 2006-04-25 22:03:35
Subject: Re: Large (8M) cache vs. dual-core CPUs

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