create.sh

application/x-shellscript

Filename: create.sh

Type: application/x-shellscript

Part: 0

Message: Lots of memory allocated when reassigning Large Objects

#!/bin/sh

createdb foodb
createuser foouser1
createuser foouser2

psql foodb <<_EOF_
grant execute on function lo_import(text) to foouser1;
_EOF_

psql -U foouser1 foodb <<_EOF_
create table foo (col oid);
insert into foo select lo_import('/dev/null') from generate_series(1,1000000);
_EOF_