Hi,
Pls find the below output of the query given in the below link.
name |
current_setting
--+-
version | PostgreSQL 8.3.5
Rajendra prasad wrote:
> Jerry Sievers wrote:
>> Rajendra prasad writes:
>>> 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.
There's a good chance you don't need all of those indexes or that
yo
Rajendra prasad wrote:
> I am not doing vacuum atall.
Please run the query on this page and post the results:
http://wiki.postgresql.org/wiki/Server_Configuration
My hope is that you are on a recent version of PostgreSQL with
autovacuum taking care of things by default.
-Kevin
--
Sent
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
Hi,
Thank you for the info. I am doing the reindex for an individual index. And
i am doing this in the live server and apps are connecting to it at the same
time. Is this not correct?
I am new to postgres. Kindly brief me the steps which i need to follow.
Prasad
On Fri, Apr 1, 2011 at 1:28 PM,
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 help brining back
> the actual size of the index. But the disk has only 4 G
How recent is the vacuum in this DB?
- Reply message -
From: "Rajendra prasad"
Date: Thu, Mar 31, 2011 11:01 pm
Subject: [ADMIN] Index size growing
To:
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 gr
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
