Nick Urbanik wrote: > Thank you Alvaro, > > On 15/05/07 18:53 -0400, Alvaro Herrera wrote: > >Instead of waiting a month for the time when you can take the > >application offline (thus accumulating a month's worth of dead tuples), > >run a non-full vacuum more often (say, once a day or more). It doesn't > >lock the table so the app can continue to be online while it runs. > > Yes, it is vacuumed non-full regularly. However, for some reason, > only a full vacuum will recover the space.
You probably need to better configure the FSM settings. See fsm_max_pages in the docs. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
