Hi Tom,
Thanks for your help. I checked types and indexes, to no avail. Vacuum
didn't help. but vacuum full did, it's now fast again.
Cheers,
Brock
On Mon, 11 Oct 2004 23:38:49 -0400, Tom Lane <[EMAIL PROTECTED]> wrote:
> Brock Henry <[EMAIL PROTECTED]> writes:
>
Hello,
I have a table with 29268 odd records. Deleting records is VERY slow,
and I don't know why.
I explained analysed the following query:
delete from people where id < '2000'
Index Scan using people_pkey on people (cost=0.00..71.68 rows=2792
width=6) (actual time=1.361..5.657 rows=2000 loop
