Re: Too much time to delete 19000 rows - Mailing list pgsql-sql

From Andrew Sullivan
Subject Re: Too much time to delete 19000 rows
Date
Msg-id 20061006182654.GA11841@phlogiston.dyndns.org
Whole thread Raw
In response to Too much time to delete 19000 rows  ("Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>)
List pgsql-sql
On Fri, Oct 06, 2006 at 03:10:01PM -0300, Ezequias Rodrigues da Rocha wrote:
> 
> BEGIN WORK;
> delete from base.ticket where session_id = 17 and cash_id = 99 and promo_id 
> = 5;
> COMMIT WORK;

Try putting EXPLAIN ANALYSE on the beginning to see what's going on. 
That said. . .

> I just think it could be occuring becouse of many constraints (7 at all)

. . .it could be, yes.  Are all the other tables &c. indexed
correctly?  VACUUMed and ANALYSEd?

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
The whole tendency of modern prose is away from concreteness.    --George Orwell


pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: timestamps over the web - suggestions
Next
From: Tom Lane
Date:
Subject: Re: Too much time to delete 19000 rows