Hi,
On Thu, Nov 06, 2008 at 04:15:02PM +0530, brahma tiwari wrote:
> My database server db01 is on linux environment and size of base folder increasing very fast unexpectedly(creating
renamedfiles of 1 GB in base folder like 1667234568.10)
This sounds like your max_fsm_pages setting is too low, so the server
cannot track free pages any more
Bump it up (there used to be a rule of thumb, IIRC it was 65536/1 GB of
data/disk space - please correct me, if I'm wrong).
IIRC, you need to restart PostgresSQL after altering that setting. A
VACUUM is prbably a good thing as well, maybe even VACUUM FULL. Do not
delete anything!
HTH,
Tino.
--
"What we nourish flourishes." - "Was wir nähren erblüht."
www.lichtkreis-chemnitz.de
www.craniosacralzentrum.de