Re: [GENERAL] bytea size limit? - Mailing list pgsql-admin

From Grzegorz Jaśkiewicz
Subject Re: [GENERAL] bytea size limit?
Date
Msg-id 2f4958ff0901210555y8b02b8dpa9db2b15873bf23a@mail.gmail.com
Whole thread Raw
In response to bytea size limit?  (paulo matadr <saddoness@yahoo.com.br>)
Responses Re: [GENERAL] bytea size limit?
List pgsql-admin
there's no real limit (its size is described with 32bit number, and
that's the only limitation here).
But you need to be aware, that content is sent over at once, so memory
is the limit in your case.

http://www.postgresql.org/docs/8.3/static/datatype-binary.html

For such large objects, it might be actually better to store them
separate as files, and just store file name.

pgsql-admin by date:

Previous
From: Kenneth Marshall
Date:
Subject: Re: bytea size limit?
Next
From: Kenneth Marshall
Date:
Subject: Re: [GENERAL] bytea size limit?