From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Diego <diego@unimedijui.com.br>
Cc: pgsql-admin@postgresql.org
Subject: Re: Delete slow...
Date: Tue, 29 Nov 2005 14:36:35 -0600
Message-ID: <1133296595.28788.75.camel@state.g2switchworks.com> (raw)
In-Reply-To: <438CC8FB.6040001@unimedijui.com.br>
References: <438CC473.9030409@unimedijui.com.br>
<1133295605.28236.1.camel@ekim>
<438CC8FB.6040001@unimedijui.com.br>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: smarlowe@g2switchworks.com, diego@unimedijui.com.br
Subject: Re: Delete slow...
In-Reply-To: <1133296595.28788.75.camel@state.g2switchworks.com>
References: <438CC473.9030409@unimedijui.com.br> <1133295605.28236.1.camel@ekim> <438CC8FB.6040001@unimedijui.com.br> <1133296595.28788.75.camel@state.g2switchworks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox