Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux