MIME-Version: 1.0
References: <CAMxxg=a0PCvrSenxkTSjTsBygh5KJ-bqOo2ZqJvGcsjdiECOWg@mail.gmail.com>
 <CAMxxg=YHe5vXM4hO9GWbSa-C8+HwFNYV+ABpcg336OwsZVvHkg@mail.gmail.com>
 <fbd82423-5553-4c84-9ceb-c3032b597bc4@aklaver.com> <CAMxxg=ZZEYEsPmiRmcmnc6TL=UjdC0hOog=pLqVH=nndxPL8Zg@mail.gmail.com>
 <7ae94444-a4cd-45da-b8c8-308cd46fc391@aklaver.com> <CAMxxg=aW-AF3+ZN=4NjO6AgxG4JUaup1EFAHmZ=DyOT6gP+qFQ@mail.gmail.com>
 <722db7f0-2d89-48ef-8f0f-9ae4191d5817@aklaver.com>
In-Reply-To: <722db7f0-2d89-48ef-8f0f-9ae4191d5817@aklaver.com>
From: pramod gupta <mail2sony2010@gmail.com>
Date: Thu, 15 Jan 2026 23:52:15 +0530
Message-ID: <CAMxxg=ZKiuMSOwvDQY-CaN6XHWV+GDLm1HGVmgJuVfBQgPdHtg@mail.gmail.com>
Subject: Re: How did VACUUM ANALYZE reclaim large TOAST bloat at disk level in
 PostgreSQL 16?
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000093de110648714e8b"
Archived-At: <https://www.postgresql.org/message-id/CAMxxg%3DZKiuMSOwvDQY-CaN6XHWV%2BGDLm1HGVmgJuVfBQgPdHtg%40mail.gmail.com>
Precedence: bulk

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

postgres@ANRPGTEST01:~$ echo $HOME
/var/lib/postgresql
postgres@ANRPGTEST01:~$

On Thu, Jan 15, 2026 at 11:27=E2=80=AFPM Adrian Klaver <adrian.klaver@aklav=
er.com>
wrote:

> On 1/15/26 09:48, pramod gupta wrote:
> Again, you need to use Reply All to get post to mailing list
> Ccinglist.
>
>
> You did not answer 2) or 3).
>
> Though the below is revealing:
>
> > postgres@ANRPGTEST01:~$ ls -ltrh /var/lib/postgresql/.pg_ai.config
> > -rw------- 1 postgres postgres 1.8K Jan 15 17:03 /var/lib/
> > postgresql/.pg_ai.config
> > postgres@ANRPGTEST01:~$ pwd
> > /var/lib/postgresql
> > postgres@ANRPGTEST01:~$ psql
> > psql (16.11 (Ubuntu 16.11-1.pgdg24.04+1))
> > Type "help" for help.
> >
> > postgres=3D# \q
>
> Per:
> https://github.com/benodiwal/pg_ai_query/issues/38
>
> "
> benodiwal last month
>
>
> Thanks for sharing, actually .pg_ai.config should be in your home
> directory and not root. Can u try to put it in home directory once and
> they try.
>
> sudheermudunuri
>
> same with me as well i added in /var/lib/postgresql/.pg_ai.config but
> still it doesn't load from the config file.
>
> benodiwal
>
>
> Hey @sudheermudunuri, it is designed this way in first release. Can u
> please try putting it in home dir.
>
> "
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>

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

<div dir=3D"ltr">postgres@ANRPGTEST01:~$ echo $HOME<br>/var/lib/postgresql<=
br>postgres@ANRPGTEST01:~$<br></div><br><div class=3D"gmail_quote gmail_quo=
te_container"><div dir=3D"ltr" class=3D"gmail_attr">On Thu, Jan 15, 2026 at=
 11:27=E2=80=AFPM Adrian Klaver &lt;<a href=3D"mailto:adrian.klaver@aklaver=
.com">adrian.klaver@aklaver.com</a>&gt; wrote:<br></div><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex">On 1/15/26 09:48, pramod gupta wrote:<br>
Again, you need to use Reply All to get post to mailing list<br>
Ccinglist.<br>
<br>
<br>
You did not answer 2) or 3).<br>
<br>
Though the below is revealing:<br>
<br>
&gt; postgres@ANRPGTEST01:~$ ls -ltrh /var/lib/postgresql/.pg_ai.config<br>
&gt; -rw------- 1 postgres postgres 1.8K Jan 15 17:03 /var/lib/ <br>
&gt; postgresql/.pg_ai.config<br>
&gt; postgres@ANRPGTEST01:~$ pwd<br>
&gt; /var/lib/postgresql<br>
&gt; postgres@ANRPGTEST01:~$ psql<br>
&gt; psql (16.11 (Ubuntu 16.11-1.pgdg24.04+1))<br>
&gt; Type &quot;help&quot; for help.<br>
&gt; <br>
&gt; postgres=3D# \q<br>
<br>
Per:<br>
<a href=3D"https://github.com/benodiwal/pg_ai_query/issues/38" rel=3D"noref=
errer" target=3D"_blank">https://github.com/benodiwal/pg_ai_query/issues/38=
</a><br>
<br>
&quot;<br>
benodiwal last month<br>
<br>
<br>
Thanks for sharing, actually .pg_ai.config should be in your home <br>
directory and not root. Can u try to put it in home directory once and <br>
they try.<br>
<br>
sudheermudunuri<br>
<br>
same with me as well i added in /var/lib/postgresql/.pg_ai.config but <br>
still it doesn&#39;t load from the config file.<br>
<br>
benodiwal<br>
<br>
<br>
Hey @sudheermudunuri, it is designed this way in first release. Can u <br>
please try putting it in home dir.<br>
<br>
&quot;<br>
<br>
-- <br>
Adrian Klaver<br>
<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_blank">adrian.klave=
r@aklaver.com</a><br>
</blockquote></div>

--00000000000093de110648714e8b--