Re: [GENERAL] out of memory with INSERT INTO... SELECT...

2008-01-15 Thread Tom Lane
Shane Ambler <[EMAIL PROTECTED]> writes: >SELECT generate_series(1,100) AS idx > , substring('abcdefghijklmnopqrstuvwxyz0123456789' from > cast((random()*36)as integer) for 1) > ||substring('abcdefghijklmnopqrstuvwxyz0123456789' from > cast((random()*36)as integer) for 1) > ||substring('a

[GENERAL] out of memory with INSERT INTO... SELECT...

2008-01-15 Thread Shane Ambler
Not real sure if this is an issue but from what I figure there is too much RAM being chewed up from this. The end result is an out of memory error (I haven't delved deeper as yet) So I am replicating what someone else is failing to get working in sqlite to see what pg can do. The end scenar