"Ilja Golshtein" <[EMAIL PROTECTED]> writes:
> PG Doc 49.2 says: "Each TOAST-able data type specifies a default strategy for
> columns of that data type". How one can find out these default strategies?
Look in pg_type, specifically the typstorage column.
Offhand I think NUMERIC is the only one t
>I am choosing the best (fastest and smallest) datatype for
>storing some 16-byte length application-level binary
>identifiers.
Addition.
I've SET STORAGE of this column to PLAIN and speed increased about 20%. Any
drawbacks of this trick?
PG Doc 49.2 says: "Each TOAST-able data type specifies a
Hello!
I am choosing the best (fastest and smallest) datatype for
storing some 16-byte length application-level binary
identifiers.
This data probably must be indexed. The only operation
I really need is comparision (equal or not) and, probably,
ORDER BY.
Most natural type BINARY(16) is absent
