Re: server space increasing very fast but transaction are very low

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