Yves Vindevogel <[EMAIL PROTECTED]> writes: > rvponp=3D# vacuum verbose tblPrintjobs ; > INFO: vacuuming "public.tblprintjobs" > [ twenty-one different indexes on one table ]
Well, there's your problem. You think updating all those indexes is free? It's *expensive*. Heed the manual's advice: avoid creating indexes you are not certain you need for identifiable commonly-used queries. (The reason delete is fast is it doesn't have to touch the indexes ... the necessary work is left to be done by VACUUM.) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings