Re: DATATYPE for HEX

From: "Ilja Golshtein" <ilejn(at)yandex(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: DATATYPE for HEX
Date: 2005-06-16 11:44:44
Message-ID: 42B1662C.000007.24913@mfront7.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 find out these default strategies?

Thanks.

--
Best regards
Ilja Golshtein

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ilja Golshtein 2005-06-16 11:48:06 Hungry postmaster
Previous Message sathish 2005-06-16 11:07:29 Experiencing problems with stored procedures