pg_repack issue

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

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.eisentraut@2ndquadrant.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

Hi Prakash,

You can run below command.

pg_repack -d dbname -E DEBUG

On Wed, Jun 5, 2019, 7:55 PM Prakash Ramakrishnan <
prakash.ramakrishnan.ap@nielsen.com> wrote:

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@gmail.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.ramakrishnan.ap@nielsen.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.eisentraut@2ndquadrant.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

Hi Prakash,

You can see all the available options from here.

http://reorg.github.io/pg_repack/#installation

On Wed, Jun 5, 2019, 8:48 PM Prakash Ramakrishnan <
prakash.ramakrishnan.ap@nielsen.com> wrote:

Hi Sathish,

Thanks i ran the pg_repack and its working fine but still the wasted bytes
not removing why?

current_database | schemaname | tablename
| tbloat | wastedbytes | i
name | ibloat | wastedibytes
------------------+-----------------------+--------------------------------------------------+--------+-------------+-------------------------------
----------------------------------+--------+--------------
AIBE01PR | lbmdigital_prod | digital_display_execution
| 1.1 | 637059072 | digital_display_exe_idx_fk14
| 0.1 | 0
AIBE01PR | lbmdigital_prod | digital_display_execution
| 1.1 | 637059072 | digital_display_exe_idx_fk22
| 0.1 | 0
AIBE01PR | lbmdigital_prod | digital_display_execution
| 1.1 | 637059072 | digital_display_exe_index4
| 0.1 | 0
AIBE01PR | lbmdigital_prod | digital_display_execution
| 1.1 | 637059072 | digital_display_exe_index3
| 0.2 | 0
AIBE01PR | lbmdigital_prod | digital_display_execution
| 1.1 | 637059072 | digital_display_exe_index1
| 0.1 | 0
AIBE01PR | lbmdigital_prod | digital_display_execution
| 1.1 | 637059072 | digital_display_execution_pkey
| 0.1 | 0
AIBE01PR | lbmdigital_prod | digital_display_execution
| 1.1 | 637059072 | digital_display_exe_idx_fk9
| 0.1 | 0
AIBE01PR | cmt_prod | cmt_creative_transfer
| 1.1 | 157155328 | cmt_creative_transfer_idx3

Regards,
Praaksh.R

On Wed, Jun 5, 2019 at 6:54 PM Sathish Kumar <satcse88@gmail.com> wrote:

Hi Prakash,

You can see all the available options from here.

http://reorg.github.io/pg_repack/#installation

On Wed, Jun 5, 2019, 8:48 PM Prakash Ramakrishnan <
prakash.ramakrishnan.ap@nielsen.com> wrote:

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@gmail.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.ramakrishnan.ap@nielsen.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.eisentraut@2ndquadrant.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

--
Thanks,
Prakash.R
PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call
: +91-8939599426