Re: Cannot Delete

From: Ang Chin Han <angch(at)bytecraft(dot)com(dot)my>
To: Alex <alex(at)meerkatsoft(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Cannot Delete
Date: 2003-10-13 06:53:02
Message-ID: 3F8A4BCE.7030504@bytecraft.com.my
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alex wrote:

> I tried vacuum, the db and tables and did not gain any performance.

Did you try VACUUM only or VACUUM ANALYZE (or even just ANALYZE)?

> I experience this problem on different machines and yet, when i reload
> the date it did speed up things considerably.

It does sound like you haven't ANALYZE'd your data. Try that.

--
Linux homer 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386
GNU/Linux
2:30pm up 291 days, 6:04, 9 users, load average: 6.08, 6.02, 6.01

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2003-10-13 07:22:58 Re: Upgrading to 7.4beta
Previous Message Dennis Gearon 2003-10-13 06:21:47 Re: Cannot Delete