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:
> > delete from people where id
Brock Henry <[EMAIL PROTECTED]> writes:
> 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 loops=1)
> Index Cond: (id < 3000)
> Total runtime: 13.006 ms
> 3 row(s)
> Total runtime: 63,869.322
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
hi,
i'm trying to tune some batches and after some research i located the
biggest problem in doing something like this:
begin;
update ts08 set ts08typ__ = ;
delete from ts08;
end;
the update takes about 1m25s (there are aprox. 7 rows in ts08). but
the delete then takes more than 20 minut
