Re: Impossibly slow DELETEs

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: schampailler(at)easynet(dot)be, pgsql-performance(at)postgresql(dot)org
Subject: Re: Impossibly slow DELETEs
Date: 2003-11-26 00:37:18
Message-ID: 9857.1069807038@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Neil Conway <neilc(at)samurai(dot)com> writes:
>> There are 6 rows in the table (given that size, I assumed that an
>> index was not necessary).

> That's a reasonable assumption.

But if he's updated those rows a few hundred thousand times and never
VACUUMed, he could be having some problems ...

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Andrew Sullivan 2003-11-26 04:27:46 Re: [PERFORM] More detail on settings for pgavd?
Previous Message Neil Conway 2003-11-25 23:55:33 Re: Impossibly slow DELETEs