Search Postgresql Archives

Re: sudden drop in delete performance

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

To: "surabhi.ahuja" <surabhi.ahuja@xxxxxxxxxxx>
Subject: Re: sudden drop in delete performance
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Wed, 29 Nov 2006 10:52:05 -0500
Cc: pgsql-general@xxxxxxxxxxxxxx
Comments: In-reply-to "surabhi.ahuja" <surabhi.ahuja@xxxxxxxxxxx> message dated "Wed, 29 Nov 2006 17:12:55 +0530"
In-reply-to: <8626C1B7EB748940BCDD7596134632BE3986BB@xxxxxxxxxxxxxxx>
References: <8626C1B7EB748940BCDD7596134632BE3986BB@xxxxxxxxxxxxxxx>

"surabhi.ahuja" <surabhi.ahuja@xxxxxxxxxxx> writes:
> I was using Postgres 8.0.0
> I have upgraded it to Postgres 8.1.5
> I have seen that the delete performance has degraded considerably.

Did you remember to re-ANALYZE your tables after transferring your database?
If so, what does EXPLAIN ANALYZE show for the slow delete?

			regards, tom lane

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

References:
- sudden drop in delete performance
  - From: surabhi.ahuja

Prev by Date: LOCK ... NOWAIT throws error
Next by Date: Re: Only MONO/WinForms is a way to go
Previous by thread: Re: sudden drop in delete performance
Next by thread: Dynamic views
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux