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

Re: sudden drop in delete performance

From: "Ben Trewern" <ben(dot)trewern(at)_nospam_mowlem(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: sudden drop in delete performance
Date: 2006-11-29 13:43:47
Message-ID: ekk2qk$121p$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-general
Did you 'vacuum analyze' after you did the update?

Make sure you have the correct indexes in place on your foreign keys.

Did you have fsync off on your previous installation?

Give some more details and I'm sure people will be able to give better advice than me.

Regards,

Ben
  ""surabhi.ahuja"" <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in> wrote in message news:8626C1B7EB748940BCDD7596134632BE3986BB(at)jal(dot)iiitb(dot)ac(dot)in(dot)(dot)(dot)
  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.

  Nothing else has changed.

  Please help
  thanks
  regards

  Surabhi

In response to

Responses

pgsql-general by date

Next:From: John McCawleyDate: 2006-11-29 15:15:03
Subject: Re: Development of cross-platform GUI for Open Source DBs
Previous:From: Richard HuxtonDate: 2006-11-29 13:33:04
Subject: Re: Looking for pgsql sysadmin

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