Postgres Pro
Downloads
Home   >   mailing lists

Re: Varbit and toast - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Varbit and toast
Date
Msg-id CAFj8pRApaLuXNn6BxSdy4Fb2fzGZANHnZbA5y4Pf+T48Z7SyCg@mail.gmail.com
Whole thread Raw
In response to Varbit and toast  (Olga Lytvynova-Bogdanova <olytvynovabogdanova@gmail.com>)
List pgsql-general
Tree view
Hi

2017-12-13 16:22 GMT+01:00 Olga Lytvynova-Bogdanova <olytvynovabogdanova@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

pgsql-general by date:

Previous
From: Yogesh Sharma
Date:
Subject: Re: Size of pg_multixact/members increases 11355
Next
From: PAWAN SHARMA
Date:
Subject: PostgreSQL Client on SUSE Enterprise Linux Server 11.