[HACKERS] query : max size Bytea

2007-12-20 Thread Arunachalam Parthasarathy
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

Re: [HACKERS] query : max size Bytea

2007-12-20 Thread Pavel Stehule
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,

Re: [HACKERS] query : max size Bytea

2007-12-20 Thread Andrew Chernow
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

Re: [HACKERS] query : max size Bytea

2007-12-20 Thread Merlin Moncure
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

Re: [HACKERS] query : max size Bytea

2007-12-20 Thread Andrew Chernow
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