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 <[EMAIL PROTECTED]> 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
>
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
