Re: Varbit and toast

[Pavel Stehule <pavel.stehule@xxxxxxxxx>]

Hi

2017-12-13 16:22 GMT+01:00 Olga Lytvynova-Bogdanova <olytvynovabogdanova@xxxxxxxxx>:

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