Re: [PERFORM] slow query : very simple delete, 100% cpu, nearly no disk activity

2009-09-06 Thread Tom Lane
Vincent de Phily writes: > I've been running this simple delete since yesterday afternoon : >> db=# explain delete from message where datetime < '2009-03-03'; >> Seq Scan on message (cost=0.00..34131.95 rows=133158 width=6) >> Filter: (datetime < '2009-03-03 00:00:00'::timestamp without time zone

[PERFORM] slow query : very simple delete, 100% cpu, nearly no disk activity

2009-09-06 Thread Vincent de Phily
Hi list, I've been running this simple delete since yesterday afternoon : > db=# explain delete from message where datetime < '2009-03-03'; > Seq Scan on message (cost=0.00..34131.95 rows=133158 width=6) >Filter: (datetime < '2009-03-03 00:00:00'::timestamp without time zone) There is no in