MIME-Version: 1.0
References: 
 <CA+M9Y+A7mUFRELeOu0g-3J+bgvf_wmuyhb+rE9X3KvLr7XQh9w@mail.gmail.com>
 <ZrIF1SiEGC_Ghsrr@depesz.com>
In-Reply-To: <ZrIF1SiEGC_Ghsrr@depesz.com>
From: Sathish Reddy <sathishreddy.postgresql@gmail.com>
Date: Tue, 6 Aug 2024 16:50:33 +0530
Message-ID: 
 <CA+M9Y+DuP6XKh8OZiv4SSp-FwVOKp6-NrgLMAKerBL31Oo7iOw@mail.gmail.com>
Subject: Re: Pg_repack
To: depesz@depesz.com
Cc: pgsql-admin@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000001c1cf3061f01fcce"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BM9Y%2BDuP6XKh8OZiv4SSp-FwVOKp6-NrgLMAKerBL31Oo7iOw%40mail.gmail.com>
Precedence: bulk

--0000000000001c1cf3061f01fcce
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Thanks for the information.please provide me solution on clearing bloating
on table or index bloating with out blocking any user and we are not run
any vaccum full .freeze, and reindex and also analized ...with out these
provide me perfect solution to run and remove bloat instance level with in
postgres..

Thanks
Sathishreddy

On Tue, Aug 6, 2024, 4:45=E2=80=AFPM hubert depesz lubaczewski <depesz@depe=
sz.com>
wrote:

> On Tue, Aug 06, 2024 at 04:39:53PM +0530, Sathish Reddy wrote:
> >   We planning to create store procedure (function) in postgres database
> to
> > run pg_repack on removing bloating of table or index by using within
> > postgres instance.
> >     Please help me on details on steps with example for same.
>
> That will be impossible and/or hard.
>
> The problem is that stored procedure/functions runs in database. and
> pg_repack is external program, that *does stuff in database*, but it not
> *all* in database.
>
> It's kinda as if you wanted to make stored procedure to run photoshop.
>
> You can kinda work around it by using some PL/* language that allows
> external program execution, but it is extremely unlikely to do what
> you'd think it will do.
>
> Best regards,
>
> depesz
>
>

--0000000000001c1cf3061f01fcce
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<p dir=3D"ltr">Thanks for the information.please provide me solution on cle=
aring bloating on table or index bloating with out blocking any user and we=
 are not run any vaccum full .freeze, and reindex and also analized ...with=
 out these provide me perfect solution to run and remove bloat instance lev=
el with in postgres..<br></p>
<p dir=3D"ltr">Thanks <br>
Sathishreddy </p>
<br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Tue=
, Aug 6, 2024, 4:45=E2=80=AFPM hubert depesz lubaczewski &lt;<a href=3D"mai=
lto:depesz@depesz.com">depesz@depesz.com</a>&gt; wrote:<br></div><blockquot=
e class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc sol=
id;padding-left:1ex">On Tue, Aug 06, 2024 at 04:39:53PM +0530, Sathish Redd=
y wrote:<br>
&gt;=C2=A0 =C2=A0We planning to create store procedure (function) in postgr=
es database to<br>
&gt; run pg_repack on removing bloating of table or index by using within<b=
r>
&gt; postgres instance.<br>
&gt;=C2=A0 =C2=A0 =C2=A0Please help me on details on steps with example for=
 same.<br>
<br>
That will be impossible and/or hard.<br>
<br>
The problem is that stored procedure/functions runs in database. and<br>
pg_repack is external program, that *does stuff in database*, but it not<br=
>
*all* in database.<br>
<br>
It&#39;s kinda as if you wanted to make stored procedure to run photoshop.<=
br>
<br>
You can kinda work around it by using some PL/* language that allows<br>
external program execution, but it is extremely unlikely to do what<br>
you&#39;d think it will do.<br>
<br>
Best regards,<br>
<br>
depesz<br>
<br>
</blockquote></div>

--0000000000001c1cf3061f01fcce--