Hi list,
The PostgreSQL documentation says in
https://www.postgresql.org/docs/15/routine-vacuuming.html#VACUUM-FOR-STATISTICS
:
*The maximum time that a table can go unvacuumed is two billion
transactions minus the vacuum_freeze_min_age value at the time of the last
aggressive vacuum.*
*...*
*
Hi List,
I am doing some tests to understand vacuum_freeze_table_age and
vacuum_freeze_min_age parameters.
Here is my configuration:
postgres=# select name, setting from pg_settings where name =
'vacuum_freeze_min_age';
name | setting
---+-
vacuum_f
I ran vacuum without the freeze option as you can see below.
Simon
On Fri, Mar 3, 2023 at 12:01 PM David Rowley wrote:
> On Fri, 3 Mar 2023 at 23:43, Simon Elbaz wrote:
> > hydrodb=# SELECT c.oid::regclass as table_name,
> >greatest(age(c.relfrozenxid),age(t.relfro
Hi,
I am following this very interesting thread.
>From the documentation
https://www.postgresql.org/docs/current/runtime-config-client.html#GUC-IDLE-IN-TRANSACTION-SESSION-TIMEOUT,
the 0 value will disable the timeout (not -1).
On Wed, Jun 5, 2024 at 8:25 AM sud wrote:
> Hello Laurenz,
>
> T
