Re: Delete slow... - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Delete slow...
Date
Msg-id 1133296595.28788.75.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: Delete slow...  (Diego <diego@unimedijui.com.br>)
Responses Re: Delete slow...
List pgsql-admin
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.

pgsql-admin by date:

Previous
From: Diego
Date:
Subject: Re: Delete slow...
Next
From: "Andrea"
Date:
Subject: Fatal : IDENT authentication