From: Rural Hunter <ruralhunter@gmail.com>
To: Sergey Konoplev <gray.ru@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Massive table bloat
Date: Wed, 12 Dec 2012 11:40:31 +0800
Message-ID: <50C7FCAF.1080502@gmail.com> (raw)
In-Reply-To: <CAL_0b1vDs8dpxFwyMwgROoWtM=QQaPvpm6rA8cQLXGP_AcU8rQ@mail.gmail.com>
References: <1355242268184-5736111.post@n5.nabble.com>
<CAL_0b1tKNmHe4Qq7fDAkpJNt2Jq8sWzKmwWtscF659x8BYuXeQ@mail.gmail.com>
<1355260487663-5736180.post@n5.nabble.com>
<CAL_0b1vDs8dpxFwyMwgROoWtM=QQaPvpm6rA8cQLXGP_AcU8rQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hi Sergey,
I downloaded pgtoolkit-v1.0beta3-fatscripts.tar.gz and tested it. I got
error when trying this:
./pgcompactor -a -u
DatabaseChooserError Can not find an adapter. at
/loader/0x1c26f18/PgToolkit/DatabaseChooser.pm line 63.
./pgcompactor -d testdb -u
DatabaseChooserError Can not find an adapter. at
/loader/0x1156f50/PgToolkit/DatabaseChooser.pm line 63.
δΊ 2012/12/12 5:27, Sergey Konoplev ει:
> On Tue, Dec 11, 2012 at 1:14 PM, Michael Sawyers <msawyers@iii.com> wrote:
>> Thanks for the tool suggestion. I already know that I will be refused
>> permission to use it on a live db for the first run here, but I will be
>> using this on several test machines that I am sure are bloated to prove the
>> point and get this added into the standard toolkit here.
> If you will have any feedback considering pgcompactor feel free to
> write me directly. I am going to publish a new release in the nearest
> days so I may include your issues in it.
>
> ps. I have been using this tool constantly on more than 40 DB servers
> for more than a year so it is tested quite good.
>
> --
> 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
>
>
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ruralhunter@gmail.com, gray.ru@gmail.com
Subject: Re: Massive table bloat
In-Reply-To: <50C7FCAF.1080502@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox