Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] index bloat problem - Mailing list pgsql-admin

From Tom Lane
Subject Re: [GENERAL] index bloat problem
Date
Msg-id 7760.1173504426@sss.pgh.pa.us
Whole thread Raw
List pgsql-admin
Tree view 
Monika Cernikova <monika@microstep-mis.com> writes:
> Can you help me how to stop index growing or reindex database if I CAN'T
> STOP writing records?

I think you have max_fsm_pages set too small.

> max_fsm_pages = 400000

That corresponds to about 3Gb, or a tenth the size of your DB.  Not enough.

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: problem upgrading from 8.1.6 to 8.1.8 --- relation does not exist
Next
From: "Rajesh Kumar Mallah"
Date:
Subject: Re: pg_dump and pg_dumpall is hanging