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 |
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...@nielsen.com> wrote:
> Hi Sathish,
>
> Thanks for quick response and the database using separate table-space and
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 wrote:
> Hi Prakash,
>
> You can r
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...@nielsen.com> wrote:
> Hi Peter,
>
> Thanks i have successfully created the extension how to use full vacuum
> using pg_repack.
>
> Regards,
> Prakash.
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.eisentr...@2ndquadrant.com> wrote:
> On 2019-06-05 12:48, Prakash Ramakrishnan wrote:
> > gcc -Wall -Wmissing-prototypes
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
> -fe
