On Wed, 2012-01-11 at 01:10 -0500, Kevin Duffy wrote: > [...] > I have run into a very frustrating problem. > > I have a database with some tables which were loaded from Excel spreadsheets > via a Perl script. Guess that does not really matter. The table > definitions > are below. > > Both tables contain 9,398,340 rows > > On a machine running Windows 7 64Bit with 6Gig of RAM > When I do a simple query, select * from estimated_idiosyncratic_ > return, on these tables I get: out of memory for query result > > If I run the same query on the machine where the database resides, > the query runs, No issue. The machine where the database resides is > laptop running Windows XP Sp2 with 3 Gig of RAM. > > Other queries run fine. > > I do not understand why these simple queries would work on a machine > with 3Gig of RAM and fail on a machine with 6Gig. > I suppose from your email's subject that you use pgAdmin on your Windows machine, and psql on the other one? If that's true, pgAdmin will probably need more memory to display the results than psql. I've tried to find the error message you're talking about, but couldn't find it in pgAdmin's code source. But I guess that, if your query returns many lines, it will hit hard on the memory. And even if it can use that much memory, the grid component can get pretty slow. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com PostgreSQL Sessions #3: http://www.postgresql-sessions.org -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
