Re: Massive table bloat

于 2012/12/12 12:24, Sergey Konoplev 写道:
> On Tue, Dec 11, 2012 at 7:57 PM, Rural Hunter <ruralhunter@gmail.com> wrote:
>> I do have psql installed. I'm on the db server.
>> $ psql
>> psql.bin (9.1.0)
>> Type "help" for help.
>>
>> postgres=# \q
>> $ ./pgcompactor -a -u
>> DatabaseChooserError Can not find an adapter. at
>> /loader/0x2539f18/PgToolkit/DatabaseChooser.pm line 63.
> You are running it with user postgres, correct?
>
> Can you show me the output of the following command, please?
>
> echo 'SELECT 1;' | psql -q -A -t -X -U postgres -P null="<NULL>"
No. I was running it with another db super user. should it only be run
by postgres?

$ echo 'SELECT 1;' | psql -q -A -t -X -U postgres -P null="<NULL>"
Password for user postgres:
1

>
>> 于 2012/12/12 11:46, Sergey Konoplev 写道:
>>
>>> On Tue, Dec 11, 2012 at 7:40 PM, Rural Hunter <ruralhunter@gmail.com>
>>> wrote:
>>>> 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.
>>> You need to have either psql or DBD::PgPP or DBD::Pg on your machine.
>>> The last one is recommended.
>>>
>>>> 于 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
>>>>>
>>>>>
>>>
>>> --
>>> 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
>>>
>
>
> --
> 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
>