| From: | Sergey Konoplev <gray(dot)ru(at)gmail(dot)com> |
|---|---|
| To: | Rural Hunter <ruralhunter(at)gmail(dot)com> |
| Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Massive table bloat |
| Date: | 2012-12-12 05:31:32 |
| Message-ID: | CAL_0b1t3CTKq9VHQDwrr1gMPCgJV=3Ro+OPK+ptf=ke_BmmLUw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Tue, Dec 11, 2012 at 9:21 PM, Rural Hunter <ruralhunter(at)gmail(dot)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(dot)ru(at)gmail(dot)com
| Attachment | Content-Type | Size |
|---|---|---|
| pgtoolkit-v1.0rc1-fatpack.tar.gz | application/x-gzip | 20.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rural Hunter | 2012-12-12 05:39:21 | Re: Massive table bloat |
| Previous Message | Rural Hunter | 2012-12-12 05:21:17 | Re: Massive table bloat |