Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: [GENERAL] index bloat problem
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Monika Cernikova <monika(at)microstep-mis(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
- Subject: Re: [GENERAL] index bloat problem
- Date: Sat, 10 Mar 2007 00:27:06 -0500
Monika Cernikova <monika(at)microstep-mis(dot)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
- Prev by Date: Re: problem upgrading from 8.1.6 to 8.1.8 --- relation <tablename> does not exist
- Next by Date: Re: pg_dump and pg_dumpall is hanging
- Previous by thread: Running in single instance mode
- Next by thread: PostgreSQL crashes on Windows 2003
- Indexes: