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@g2switchworks.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.