Re: pgAdmin - Query - out of memory for query result

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