Re: Impossibly slow DELETEs - Mailing list pgsql-performance

From Tom Lane
Subject Re: Impossibly slow DELETEs
Date
Msg-id 9857.1069807038@sss.pgh.pa.us
Whole thread Raw
In response to Re: Impossibly slow DELETEs  (Neil Conway <neilc@samurai.com>)
List pgsql-performance
Neil Conway <neilc@samurai.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

pgsql-performance by date:

Previous
From: Neil Conway
Date:
Subject: Re: Impossibly slow DELETEs
Next
From: Shridhar Daithankar
Date:
Subject: Re: Optimize