Postgres Pro
Downloads
Home   >   mailing lists

Re: autovacuum doesnt run on the pg_toast_id table - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: autovacuum doesnt run on the pg_toast_id table
Date
Msg-id 201901172016.4qasdchkt3lc@alvherre.pgsql
Whole thread Raw
In response to Re: autovacuum doesnt run on the pg_toast_id table  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Responses Re: autovacuum doesnt run on the pg_toast_id table  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
List pgsql-performance
Tree view 
On 2019-Jan-17, Mariel Cherkassky wrote:

> But you said that the threshold that is chosen for the toasted table is
> identical to the originals table threshold right ?

You can configure them identical, or different.  Up to you.

> Is that a normal behavior that the original table has 1000recrods but
> the toasted has more than 10m?

Sure -- each large record in the main table is split into many 2kb
records in the toast table.

> How can I set a different threshold for the toasted table ?

Just choose a different value in the command I showed.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-performance by date:

Previous
From: Mariel Cherkassky
Date:
Subject: Re: autovacuum doesnt run on the pg_toast_id table
Next
From: Mariel Cherkassky
Date:
Subject: Re: autovacuum doesnt run on the pg_toast_id table