Hi 2017-12-13 16:22 GMT+01:00 Olga Lytvynova-Bogdanova < olytvynovabogdan...@gmail.com>:
> Hello, > I would like to ask whether is VARBIT a TOAST-able type and table should > support row insertion with VARBIT values more than 8 KB in size thus? > Regards > Olha > postgres=# select * from pg_type where typname = 'varbit'; +-[ RECORD 1 ]---+-----------------+ | typname | varbit | | typnamespace | 11 | | typowner | 10 | | typlen | -1 | | typbyval | f | | typtype | b | | typcategory | V | | typispreferred | t | | typisdefined | t | | typdelim | , | | typrelid | 0 | | typelem | 0 | | typarray | 1563 | | typinput | varbit_in | | typoutput | varbit_out | | typreceive | varbit_recv | | typsend | varbit_send | | typmodin | varbittypmodin | | typmodout | varbittypmodout | | typanalyze | - | | typalign | i | | typstorage | x | | typnotnull | f | | typbasetype | 0 | | typtypmod | -1 | | typndims | 0 | | typcollation | 0 | | typdefaultbin | | | typdefault | | | typacl | | +----------------+-----------------+ look https://www.postgresql.org/docs/current/static/catalog-pg-type.html typstorage = 'x' x: Value can be stored compressed inline or stored in “secondary” storage. Regards Pavel
