"Carlos H. Reimer" <carlos.reimer@xxxxxxxxxxxxx> writes: > When one of the biggest tables has all lines updated for example, it takes > at about 30 minutes for processing. If we drop all indexes (21) and let only > the primary index the same update takes 2 minutes. 21 indexes?? If update performance is important then you should try to economize on indexes. Do you have evidence that each of those indexes is worth its update costs? regards, tom lane
