Re: 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

On 20/12/2007, Arunachalam Parthasarathy <arunachalamamsam(at)gmail(dot)com> 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
>