Content-Type: multipart/alternative;
 boundary=Apple-Mail-8D50908C-B986-4154-90B3-A45EDB2F28CC
Content-Transfer-Encoding: 7bit
From: abbas alizadeh <ramkly@yahoo.com>
Mime-Version: 1.0 (1.0)
Subject: Re: Pg_repack
Date: Tue, 6 Aug 2024 14:54:28 +0330
Message-Id: <BBA040D2-0FAB-4B68-807F-5213E0D7A58D@yahoo.com>
References: 
 <CA+M9Y+DuP6XKh8OZiv4SSp-FwVOKp6-NrgLMAKerBL31Oo7iOw@mail.gmail.com>
Cc: depesz@depesz.com, pgsql-admin@lists.postgresql.org
In-Reply-To: 
 <CA+M9Y+DuP6XKh8OZiv4SSp-FwVOKp6-NrgLMAKerBL31Oo7iOw@mail.gmail.com>
To: Sathish Reddy <sathishreddy.postgresql@gmail.com>
Content-Length: 2399
Archived-At: 
 <https://www.postgresql.org/message-id/BBA040D2-0FAB-4B68-807F-5213E0D7A58D%40yahoo.com>
Precedence: bulk


--Apple-Mail-8D50908C-B986-4154-90B3-A45EDB2F28CC
Content-Type: text/html;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto">Hi<div>Why you don=E2=80=99t use pg_squeeze=
?</div><div>It has its own scheduling to remove bloating.</div><div><br id=3D=
"lineBreakAtBeginningOfSignature"><div dir=3D"ltr">Regards<div>Abbas</div></=
div><div dir=3D"ltr"><br><blockquote type=3D"cite">On 6 Aug 2024, at 2:51=E2=
=80=AFPM, Sathish Reddy &lt;sathishreddy.postgresql@gmail.com&gt; wrote:<br>=
<br></blockquote></div><blockquote type=3D"cite"><div dir=3D"ltr">=EF=BB=BF<=
p dir=3D"ltr">Thanks for the information.please provide me solution on clear=
ing bloating on table or index bloating with out blocking any user and we ar=
e 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 wi=
th 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"mailt=
o:depesz@depesz.com">depesz@depesz.com</a>&gt; wrote:<br></div><blockquote c=
lass=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;p=
adding-left:1ex">On Tue, Aug 06, 2024 at 04:39:53PM +0530, Sathish Reddy wro=
te:<br>
&gt;&nbsp; &nbsp;We planning to create store procedure (function) in postgre=
s database to<br>
&gt; run pg_repack on removing bloating of table or index by using within<br=
>
&gt; postgres instance.<br>
&gt;&nbsp; &nbsp; &nbsp;Please help me on details on steps with example for s=
ame.<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'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'd think it will do.<br>
<br>
Best regards,<br>
<br>
depesz<br>
<br>
</blockquote></div>
</div></blockquote></div></body></html>=

--Apple-Mail-8D50908C-B986-4154-90B3-A45EDB2F28CC--