Re: autovacuum doesnt run on the pg_toast_id table

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