Re: How did VACUUM ANALYZE reclaim large TOAST bloat at disk level in PostgreSQL 16?

On 1/15/26 10:22, pramod gupta wrote:
> postgres(at)ANRPGTEST01:~$ echo $HOME
> /var/lib/postgresql
> postgres(at)ANRPGTEST01:~$

I have to believe the extension author is referring to a user
/home/some_user/ directory.

How are you getting to postgres(at)ANRPGTEST01?

What happens if you try something like?:

sudo -u postgres psql -d postgres -U postgres

>
> On Thu, Jan 15, 2026 at 11:27 PM Adrian Klaver
> <adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)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(at)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(at)ANRPGTEST01:~$ pwd
> > /var/lib/postgresql
> > postgres(at)ANRPGTEST01:~$ psql
> > psql (16.11 (Ubuntu 16.11-1.pgdg24.04+1))
> > Type "help" for help.
> >
> > postgres=# \q
>
> Per:
> https://github.com/benodiwal/pg_ai_query/issues/38 <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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com