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
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,
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
On Dec 20, 2007 12:47 PM, Andrew Chernow [EMAIL PROTECTED] 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
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