Re: Massive table bloat - Mailing list pgsql-admin

From Sergey Konoplev
Subject Re: Massive table bloat
Date
Msg-id CAL_0b1t3CTKq9VHQDwrr1gMPCgJV=3Ro+OPK+ptf=ke_BmmLUw@mail.gmail.com
Whole thread Raw
In response to Re: Massive table bloat  (Rural Hunter <ruralhunter@gmail.com>)
Responses Re: Massive table bloat
List pgsql-admin
On Tue, Dec 11, 2012 at 9:21 PM, Rural Hunter <ruralhunter@gmail.com> wrote:
> Ok, thanks. I installed dbd::pg. Now I can run it with specify additional
> parameters(-h, -p). Seems pgcompactor doesn't read them from env variables.
> However, I met another error when pgcompactor processes tables. Seems it
> doesn't expect some tables with autovacuum off:
> ERROR A database error occurred, exiting:
> DatabaseError DBD::Pg::st execute failed: ERROR:  invalid input syntax for
> type real: "{autovacuum_enabled=false}" [for Statement "SELECT

Yes. It is known bug and it is fixed in the future (not yet released) version.

See the attachment.

--
Sergey Konoplev
Database and Software Architect
http://www.linkedin.com/in/grayhemp

Phones:
USA +1 415 867 9984
Russia, Moscow +7 901 903 0499
Russia, Krasnodar +7 988 888 1979

Skype: gray-hemp
Jabber: gray.ru@gmail.com

Attachment

pgsql-admin by date:

Previous
From: Rural Hunter
Date:
Subject: Re: Massive table bloat
Next
From: Rural Hunter
Date:
Subject: Re: Massive table bloat