Re: [PERFORM] Query Fails with error calloc - Cannot alocate memory

2005-12-06 Thread Neil Conway
On Mon, 2005-12-05 at 09:42 +0200, Howard Oblowitz wrote: > I am trying to run a query that selects 26 million rows from a > table with 68 byte rows. > > When run on the Server via psql the following error occurs: > > calloc : Cannot allocate memory That's precisely what I'd expect: the backend

Re: [PERFORM] Query Fails with error calloc - Cannot alocate memory

2005-12-06 Thread Christopher Kings-Lynne
If you're trying to retrieve 26 million rows into RAM in one go of course it'll be trouble. Just use a cursor. (DECLARE/FETCH/MOVE) Chris Howard Oblowitz wrote: Hi … I am trying to run a query that selects 26 million rows from a table with 68 byte rows. When run on the Server via psql th

[PERFORM] Query Fails with error calloc - Cannot alocate memory

2005-12-06 Thread Howard Oblowitz
Title: Query Fails with error calloc - Cannot alocate memory Hi … I am trying to run a query that selects 26 million rows from a table with 68 byte rows. When run on the Server via psql the following error occurs: calloc : Cannot allocate memory When run via ODBC from Cognos Framework Ma