Karl Wright wrote: > Alvaro Herrera wrote: > >Karl Wright wrote: > > > >>(b) the performance of individual queries had already degraded > >>significantly in the same manner as what I'd seen before. > > > >You didn't answer whether you had smaller, more frequently updated > >tables that need more vacuuming. This comment makes me think you do. I > >think what you should be looking at is whether you can forget vacuuming > >the whole database in one go, and make it more granular. > > I am afraid that I did answer this. My largest tables are the ones > continually being updated. The smaller ones are updated only infrequently.
Can you afford to vacuum them in parallel? -- Alvaro Herrera http://www.amazon.com/gp/registry/5ZYLFMCVHXC "Java is clearly an example of money oriented programming" (A. Stepanov) ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
