query : max size Bytea

Hello

there are limits:
Maximum size for a table? 16 TB
Maximum size for a row? 1.6TB
Maximum size for a field? 1 GB

But my experience is, on older servers with RAM < 2G is +/- 20M long
bytea slow and it is better use BLOB, that is much faster for longer
items.

Regards
Pavel Stehule

Arunachalam Parthasarathy wrote:

hi,
i would request you to answer the following query:

1. What is the maximum size of data single Bytea entry in column?

i would be thankful to you for the above request
.
P.S : my current reqirement is to add more that 1 gb of data in a
single entry of type bytea column in each row.

Thanks and regards
Arunachalam

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

bytea uses up to 4 bytes to represent the binary string length (signed
32-bit integer). So the max data size is 2G.

http://www.postgresql.org/docs/8.3/static/datatype-binary.html

andrew

On Dec 20, 2007 12:47 PM, Andrew Chernow <ac@esilo.com> wrote:

Arunachalam Parthasarathy wrote:
bytea uses up to 4 bytes to represent the binary string length (signed
32-bit integer). So the max data size is 2G.

max data size is 2g, but only large objects can hit that...1gb limit
comes from toast and applies to pretty much anything else
(http://www.postgresql.org/docs/8.3/static/storage-toast.html).

merlin

Andrew Chernow wrote:

Arunachalam Parthasarathy wrote:

hi,
i would request you to answer the following query:

1. What is the maximum size of data single Bytea entry in column?

i would be thankful to you for the above request
.
P.S : my current reqirement is to add more that 1 gb of data in a
single entry of type bytea column in each row.

Thanks and regards
Arunachalam

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

bytea uses up to 4 bytes to represent the binary string length (signed
32-bit integer). So the max data size is 2G.

http://www.postgresql.org/docs/8.3/static/datatype-binary.html

andrew

Sorry, my mistake. Max size is 1G. oops.

andrew