From: | Prakash Ramakrishnan <prakash(dot)ramakrishnan(dot)ap(at)nielsen(dot)com> |
---|---|
To: | Sathish Kumar <satcse88(at)gmail(dot)com> |
Cc: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: pg_repack issue |
Date: | 2019-06-05 12:48:06 |
Message-ID: | CAA2eZXw-=3c_qhS2mMEPhLyrtMrjpEs0BFQri8UZQF+Ki-RTbA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Sathish,
Thanks for quick response and the database using separate table-space and
we need to clear table and index bloat values and using jobs also how can i
achieve this need exact command ?
Regards,
Prakash.R
On Wed, Jun 5, 2019 at 6:16 PM Sathish Kumar <satcse88(at)gmail(dot)com> wrote:
> Hi Prakash,
>
> You can run below command.
>
> pg_repack -d dbname -E DEBUG
>
>
> On Wed, Jun 5, 2019, 7:55 PM Prakash Ramakrishnan <
> prakash(dot)ramakrishnan(dot)ap(at)nielsen(dot)com> wrote:
>
>> Hi Peter,
>>
>> Thanks i have successfully created the extension how to use full vacuum
>> using pg_repack.
>>
>> Regards,
>> Prakash.R
>>
>> On Wed, Jun 5, 2019 at 5:23 PM Peter Eisentraut <
>> peter(dot)eisentraut(at)2ndquadrant(dot)com> wrote:
>>
>>> On 2019-06-05 12:48, Prakash Ramakrishnan wrote:
>>> > gcc -Wall -Wmissing-prototypes -Wpointer-arith
>>> > -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
>>> > -Wformat-security -fno-strict-aliasing -fwrapv
>>> > -fexcess-precision=standard -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2
>>> > -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4
>>> > -grecord-gcc-switches -m64 -mtune=generic pg_repack.o pgut/pgut.o
>>> > pgut/pgut-fe.o -L/usr/pgsql-11/lib -Wl,--as-needed
>>> > -L/usr/lib64/llvm5.0/lib -L/usr/lib64 -Wl,--as-needed
>>> > -Wl,-rpath,'/usr/pgsql-11/lib',--enable-new-dtags -L/usr/pgsql-11/lib
>>> > -lpq -L/usr/pgsql-11/lib -lpgcommon -lpgport -lpthread -lssl -lcrypto
>>> > -lz -lreadline -lrt -lcrypt -ldl -lm -o pg_repack
>>> > */usr/bin/ld: cannot find -lreadline
>>> > collect2: error: ld returned 1 exit status
>>> > make[1]: *** [pg_repack] Error 1
>>> > make[1]: Leaving directory
>>> `/home/postgres/software/pg_repack-1.4.4/bin'
>>> > make: *** [all] Error 2*
>>>
>>> It's a bit bogus that pg_repack would require this, but perhaps
>>> installing the readline-devel (or similar) package would get you past
>>> this.
>>>
>>> --
>>> Peter Eisentraut http://www.2ndQuadrant.com/
>>> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>>>
>>
>>
>> --
>> Thanks,
>> Prakash.R
>> PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On
>> call : +91-8939599426
>>
>
--
Thanks,
Prakash.R
PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call
: +91-8939599426
From | Date | Subject | |
---|---|---|---|
Next Message | Sathish Kumar | 2019-06-05 13:24:35 | Re: pg_repack issue |
Previous Message | Domen Šetar | 2019-06-05 12:46:44 | Postgresql-11 confusing situtation |