Skip site navigation (1) Skip section navigation (2)

Re: Delete slow...

From: Guido Barosio <gbarosio(at)gmail(dot)com>
To: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
Cc: Diego <diego(at)unimedijui(dot)com(dot)br>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Delete slow...
Date: 2005-11-29 21:47:16
Message-ID: f7f6b4c70511291347h7abfde90r3e7c0d8c974f63c5@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-es-ayuda
A good idea would be to:

1) if your spanish is strong enough, post into the -es mailing list and
kindly request for help there.
(Si tu espaniol es fuerte, escribi a la lista -es, te vas a encontrar mas
comodo con las posibles respuestas)

2) if your spanish isn't strong enough, post here again, but show us:

a) The SQL statement being used [aka the query]
b) The description of the tables involved [in your pgsql shell `\d
tablename`
c) Your server specs (OS, version, hd, ram, cpu,etc)

If you usually run this query, and it works faster you may be facing a load
in the database or in the server, or in both at the same time. Can you
ensure if this is not the case?

3) if your spanish is poor, and your english is poor, but you have enough
time, then teach us portugues :)

Best regards,
Guido Barosio
Camberley, Surrey
United Kingdom


On 11/29/05, Scott Marlowe <smarlowe(at)g2switchworks(dot)com> wrote:
>
> 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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>



--
"Adopting the position that you are smarter than an automatic
optimization algorithm is generally a good way to achieve less
performance, not more" - Tom Lane.

In response to

pgsql-admin by date

Next:From: Guido BarosioDate: 2005-11-29 21:49:56
Subject: Re: invalid length of startup packet
Previous:From: Dan The ManDate: 2005-11-29 21:45:16
Subject: invalid length of startup packet

pgsql-es-ayuda by date

Next:From: Raul CasoDate: 2005-11-29 21:50:00
Subject: Re: Consulta sobre Set Returning Functions con Record
Previous:From: Martín MarquésDate: 2005-11-29 21:45:24
Subject: Re: registro de operaciones

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group