2005/8/30, Alvaro Herrera <alvherre@xxxxxxxxxxxxxx>: > On Tue, Aug 30, 2005 at 10:18:20AM -0300, Clodoaldo Pinto wrote: > > A vacuum full or a cluster is totally out of reach since each take > > about one hour. > > Even if you cluster/vacuum only the just-loaded table? > No, that would be much faster. The biggest just updated is about 600 thousand rows. I will consider it. > > The biggest table is 170 million rows long. > > I hope this is not the one you are loading daily ... > I load daily 8 times 700+ thousand rows. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
