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,
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
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
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 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
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)---
