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 renamed files 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
