Tomas Vondra wrote: > > Huh, I didn't suggest to dump/reload. I suggested CLUSTER. You need to > > apply it only to tables where you have lots of dead tuples, which IIRC > > are A, C and D. > > Sorry, I should read more carefully. Will clustering a table according > to one index solve problems with all the indexes on the table (if the > table has for example two indexes?).
Yes, it will rebuild all indexes. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
