Re: Delete slow...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux