Postgres Pro
Downloads
Home   >   mailing lists

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

From Mariel Cherkassky
Subject Re: autovacuum doesnt run on the pg_toast_id table
Date
Msg-id CA+t6e1nBK6vHJSp39K9=DKsr-SyWZP02gzzC-XEUp7P9A8eoPA@mail.gmail.com
Whole thread Raw
In response to Re: autovacuum doesnt run on the pg_toast_id table  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-performance
Tree view
Got it, I didn't see the toast word in the command. Thanks !

On Thu, Jan 17, 2019, 10:17 PM Alvaro Herrera <alvherre@2ndquadrant.com wrote:
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: Alvaro Herrera
Date:
Subject: Re: autovacuum doesnt run on the pg_toast_id table
Next
From: Luis Carril
Date:
Subject: JIT overhead slowdown