Re: [ADMIN] Index size growing

2011-04-02 Thread Rajendra prasad
max_stack_depth | 2MB server_encoding | UTF8 shared_buffers | 768MB silent_mode | on TimeZone | Europe/Brussels work_mem | 2MB Prasad On Fri, Apr 1, 2011 at 8:23 PM, Kevin Grittner wrote: > Rajen

Re: [ADMIN] Index size growing

2011-04-01 Thread Rajendra prasad
Hi, I am not doing vacuum atall. Prasad On Fri, Apr 1, 2011 at 12:06 PM, scorpda...@hotmail.com < scorpda...@hotmail.com> wrote: > How recent is the vacuum in this DB? > > > > - Reply message ----- > From: "Rajendra prasad" > Date: Thu, Mar 31, 2011 1

Re: [ADMIN] Index size growing

2011-04-01 Thread Rajendra prasad
, Jerry Sievers wrote: > Rajendra prasad writes: > > > Hi, > > > > I have 50 GB data base folder for postgres. Out of 50 GB 20 GB has > > been occupied by 8 indexes of a single table by growing upto 2 GB > > each. I googled and got the info that reindex will h

[ADMIN] Index size growing

2011-04-01 Thread Rajendra prasad
Hi, I have 50 GB data base folder for postgres. Out of 50 GB 20 GB has been occupied by 8 indexes of a single table by growing upto 2 GB each. I googled and got the info that reindex will help brining back the actual size of the index. But the disk has only 4 GB left . Due to this, when i run rein