Got it, I didn't see the toast word in the command. Thanks !
On Thu, Jan 17, 2019, 10:17 PM Alvaro Herrera <alvherre@xxxxxxxxxxxxxxx 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
