From: | Rajendra prasad <rajendra(dot)dn(at)gmail(dot)com> |
---|---|
To: | "scorpdaddy(at)hotmail(dot)com" <scorpdaddy(at)hotmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Index size growing |
Date: | 2011-04-01 12:09:50 |
Message-ID: | AANLkTi=REiDGjv9bmzkFBhHEScDvqq6zUvBj-Q8Tu-q4@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
I am not doing vacuum atall.
Prasad
On Fri, Apr 1, 2011 at 12:06 PM, scorpdaddy(at)hotmail(dot)com <
scorpdaddy(at)hotmail(dot)com> wrote:
> How recent is the vacuum in this DB?
>
>
>
> ----- Reply message -----
> From: "Rajendra prasad" <rajendra(dot)dn(at)gmail(dot)com>
> Date: Thu, Mar 31, 2011 11:01 pm
> Subject: [ADMIN] Index size growing
> To: <pgsql-admin(at)postgresql(dot)org>
>
>
> 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 reindex it
> is getting almost full. I don't know exactly why it is growing like that
> during reindex. Due to this i am not able to complete the reindex and see
> if
> i get back the disk spacce. Please suggest me a good solution and the way
> that i am doing is logical or not.
>
> Regards,
> Rajendra
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | bilal ghayyad | 2011-04-01 12:11:33 | Fedora core 10: tcpip_socket = True |
Previous Message | Rajendra prasad | 2011-04-01 12:08:48 | Re: Index size growing |