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
Thanks
Diego Ziquinatti
---(end of broadcast)---
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
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, r
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 h
Can you provide the output of EXPLAIN ANALYZE for one of these deletes?
On Tue, Nov 29, 2005 at 06:32:43PM -0300, 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 spende
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,