Thank you all for providing me important details. I will certainly follow
them to fix the issue I have
Regards
On Mon, Apr 26, 2010 at 11:53 AM, wrote:
>
>
> pgsql-general-ow...@postgresql.org wrote on 04/26/2010 03:43:03 PM:
>
> > Hi All -
> >
> > I have a table bloated with
pgsql-general-ow...@postgresql.org wrote on 04/26/2010 03:43:03 PM:
> Hi All -
>
> I have a table bloated with following details
> rows:29431 pages:516039 shouldbe:534 (966.4X) wasted size:4223016960(3
GB) *
>
> I did a vacuum on the database and also I did
akp geek writes:
> * "Orders": found 0 removable, 27164544 nonremovable row versions in 518971
> pages*
> *DETAIL: 27126176 dead row versions cannot be removed yet.*
So there isn't anything vacuum can do right now. You've apparently got
an old open transaction, which is blocking vacuum from rem
2010/4/26 Cédric Villemain :
> 2010/4/26 akp geek :
>> Hi All -
>> I have a table bloated with following details
>> rows:29431 pages:516039 shouldbe:534 (966.4X) wasted size:4223016960 (3 GB)
>> *
>
> I think this info come from check_postgres nagios script.
> As said in the doc,
*What I did was, I issued the following command *
*
*
*$vacuumdb -d prodDB -t orders -f -z -v
*
*
*
*
*
* "Orders": found 0 removable, 27164544 nonremovable row versions in 518971
pages*
*DETAIL: 27126176 dead row versions cannot be removed yet.*
*Nonremovable row versions range from 118 to 213
2010/4/26 akp geek :
> Hi All -
> I have a table bloated with following details
> rows:29431 pages:516039 shouldbe:534 (966.4X) wasted size:4223016960 (3 GB)
> *
I think this info come from check_postgres nagios script.
As said in the doc, this info is not 100% sure : it depend o
In response to akp geek :
> Hi All -
>
> I have a table bloated with following details
> rows:29431 pages:516039 shouldbe:534 (966.4X) wasted size:4223016960 (3 GB)
> *
>
> I did a vacuum on the database and also I did vacuumdb
> full on the table. Still ther
