my data directory is just 1.7G On Tuesday 10 May 2005 14:33, Frank Finner wrote: > On Tue, 10 May 2005 12:19:43 +0800 Jerome Macaranas <jerome@xxxxxxxxx> thought long, then sat down and wrote: > > im using RH9 > > > > postgres 7.3.4 > > Maybe you ran into the same problem I had about a year ago. See > http://archives.postgresql.org/pgsql-general/2004-03/msg00810.php and > thread. My database became extremely slow, vacuum itself needed several > hours instead of several minutes, after doing some weeks of heavy > inserting. > > Vaccum obviously does not release all unused memory in 7.3.x. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)