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

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Rob Sargent <robjsargent(at)gmail(dot)com>
Cc: pramod gupta <mail2sony2010(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How did VACUUM ANALYZE reclaim large TOAST bloat at disk level in PostgreSQL 16?
Date: 2026-01-15 19:24:33
Message-ID: 64ad4f15-20cd-4370-ba18-92399bbc5271@aklaver.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 1/15/26 10:55, Rob Sargent wrote:
>
>
>> On Jan 15, 2026, at 11:52 AM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>>
>> On 1/15/26 10:22, pramod gupta wrote:
>>> postgres(at)ANRPGTEST01:~$ echo $HOME
>>> /var/lib/postgresql
>>> postgres(at)ANRPGTEST01:~$
>>
>> Should have added to previous post:
>>
>> Another thing to try is copy/move .pg_ai.config to your home directory and run psql from there.
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com
>>
> Is this a hijacked thread?

Same author. I am not sure if what they are attempting with pg_ai_query
is related to the original post or not.

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Guo 2026-01-16 03:27:36 Re: Fwd: pg18 bug? SELECT query doesn't work
Previous Message Rob Sargent 2026-01-15 18:55:32 Re: How did VACUUM ANALYZE reclaim large TOAST bloat at disk level in PostgreSQL 16?