Re: Massive table bloat

Поиск
Список
Период
Сортировка
От Sergey Konoplev
Тема Re: Massive table bloat
Дата
Msg-id CAL_0b1t3CTKq9VHQDwrr1gMPCgJV=3Ro+OPK+ptf=ke_BmmLUw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Massive table bloat  (Rural Hunter <ruralhunter@gmail.com>)
Ответы Re: Massive table bloat  (Rural Hunter <ruralhunter@gmail.com>)
Список 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

Вложения

В списке pgsql-admin по дате отправления:

Предыдущее
От: Rural Hunter
Дата:
Сообщение: Re: Massive table bloat
Следующее
От: Rural Hunter
Дата:
Сообщение: Re: Massive table bloat