Re: Delete slow...

On Tue, 2005-11-29 at 15:32, Diego wrote:
> Thanks by answers...
>
> For each record deleted, my postgresql server spended 4 seconds...
> I know because i have logged each sql instruction, showing the time spended.
>
> My question is: is normal this time to a big table (400,000 records)

Do you have any foreign keys involved here?  You might need some indexes
for faster lookups.

And don't worry about your english, I'm sure it's 1,000 times better
than most of our Portuguese.