Re: DATATYPE for HEX - Mailing list pgsql-general

From Ilja Golshtein
Subject Re: DATATYPE for HEX
Date
Msg-id 42B1662C.000007.24913@mfront7.yandex.ru
Whole thread Raw
In response to DATATYPE for HEX  ("Ilja Golshtein" <ilejn@yandex.ru>)
Responses Re: DATATYPE for HEX
List pgsql-general
>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 default strategy for columns of that data type". How one can
findout these default strategies? 


Thanks.

--
Best regards
Ilja Golshtein

pgsql-general by date:

Previous
From: Sean Davis
Date:
Subject: Re: Dynamic SQL
Next
From: "Ilja Golshtein"
Date:
Subject: Hungry postmaster