>>> Rows are sent back in the entireity, so the PG instance would need >>> enough memory to work with that row. When you're running a 32bit >>> version of PG, values whose size is beyond ~100MB are a bit touch and go >>> whether it will work. > >> ?? I hear that it's posible to store up to a GiB as a value for a "text" field. >> How would i possibly retrieve that data from the database? > > That's the *theoretical* limit. In a 32-bit build, the practical limit > is going to be quite a bit less. Sheesh.. - why? - how about 64 bit? - should this be documented? -- "Patriotism is the conviction that your country is superior to all others because you were born in it." -- George Bernard Shaw -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
