Re: [GENERAL] pgAdmin - Query - out of memory for query result

2012-01-11 Thread Kevin Duffy
I am using pgAdmin on both machines. And for some strange reason the query fails on the machine with more memory. The message shows up in the Output pane in the messages tab. I do not get it. KD On Wed, Jan 11, 2012 at 8:50 AM, Guillaume Lelarge wrote: > On Wed, 2012-01-11 at 01:10 -0500, Ke

Re: [GENERAL] pgAdmin - Query - out of memory for query result

2012-01-11 Thread Guillaume Lelarge
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 tabl

[GENERAL] pgAdmin - Query - out of memory for query result

2012-01-10 Thread Kevin Duffy
Hello: 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