Re: inserting huge file into bytea cause out of memory - Mailing list pgsql-general

Hi,

On 6 Srpen 2013, 9:12, liuyuanyuan wrote:

Table defination: 

     create table image_bytea(t_id int, t_image  bytea);

 Major code:

     String sql = "insert into image_bytea(t_id, t_image) values (?, ?)";

     ps = conn.prepareStatement(sql);

    ps.setInt(1, 88);

     File file = new file("d://1.jpg"); 

    InputStream in = new BufferedInputStream(new FileInputStream(file));

     ps.setBinaryStream(2, in, (int) file.length());

     System.out.println("set");

     ps.executeUpdate();
Error detail:
     org.postgresql.util.PSQLException: Error: out of memory
     Details:Failed on request of size 268443660.

Seems like an issue with the OS, not with PostgreSQL, to me.

What OS and HW are you using? How much memory you have and do you have
some user limits in place? For example Linux uses ulimit and some kernel
parameters to limit how much memory can be allocated by a process.