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@gmail.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
>