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 -- Mario Splivalo Mob-Art [EMAIL PROTECTED] "I can do it quick, I can do it cheap, I can do it well. Pick any two." ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings