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)
Thanks!
Diego Ziquinatti
From Brazil (excuse me my english, rsrsrs)
Mario Splivalo escreveu:
On Tue, 2005-11-29 at 18:13 -0300, Diego wrote:
Hi,
I have a table with 400,000 records, but in delete comand is very slow
(4 seconds for operation)
Why is very slow? There is some special configuration for this?
Ps.: Version = Postgresql 7.4.6
That smells like a bad design. What do you delete from a 400.000 records
table?
I guess it's ok to be slow.
Mike
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
