Re: slow deletes on pgsql 7.4

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Junaili Lie" <junaili@xxxxxxxxx>
Subject: Re: slow deletes on pgsql 7.4
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Tue, 25 Apr 2006 21:04:34 -0400
Cc: pgsql-performance@xxxxxxxxxxxxxx
Comments: In-reply-to "Junaili Lie" <junaili@xxxxxxxxx> message dated "Tue, 25 Apr 2006 17:14:56 -0700"
In-reply-to: <8d04ce990604251714g1f5d99bbn172ec554a49c8374@xxxxxxxxxxxxxx>
References: <8d04ce990604251441ya85c42evb47946272536cabe@xxxxxxxxxxxxxx> <9147.1146006558@xxxxxxxxxxxxx> <8d04ce990604251714g1f5d99bbn172ec554a49c8374@xxxxxxxxxxxxxx>

"Junaili Lie" <junaili@xxxxxxxxx> writes:
> ie. delete from scenario where id=3D'1023' is very fast, but delete from
> scenario where id=3D'1099' is running forever.

What does EXPLAIN show for each of those cases?

			regards, tom lane

Follow-Ups:
- Re: slow deletes on pgsql 7.4
  - From: Junaili Lie

References:
- slow deletes on pgsql 7.4
  - From: Junaili Lie
- Re: slow deletes on pgsql 7.4
  - From: Tom Lane
- Re: slow deletes on pgsql 7.4
  - From: Junaili Lie

Prev by Date: Re: Large (8M) cache vs. dual-core CPUs
Next by Date: Re: Large (8M) cache vs. dual-core CPUs
Previous by thread: Re: slow deletes on pgsql 7.4
Next by thread: Re: slow deletes on pgsql 7.4
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux