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