Re: autovacuum doesnt run on the pg_toast_id table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux