pgAdmin - Query - out of memory for query result

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 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.

Your kind assistance is requested.

KD

-- DROP TABLE estimated_systematic_return;

CREATE TABLE estimated_systematic_return
(
est_systematic_return_key serial NOT NULL,
ws_run_key integer,
fund_key integer NOT NULL,
period integer,
period_index integer,
period_yyyymm integer,
est_systematic_return_value numeric(30,20) NOT NULL,
CONSTRAINT est_systematic_return_pk PRIMARY KEY
(est_systematic_return_key )
)
WITH (
OIDS=FALSE
);
ALTER TABLE estimated_systematic_return
OWNER TO postgres;

-- Index: estimated_systematic_return_ws_run_key

-- DROP INDEX estimated_systematic_return_ws_run_key;

CREATE INDEX estimated_systematic_return_ws_run_key
ON estimated_systematic_return
USING btree
(ws_run_key );

-- DROP TABLE estimated_idiosyncratic_return;

CREATE TABLE estimated_idiosyncratic_return
(
est_idiosyncratic_return_key serial NOT NULL,
ws_run_key integer,
fund_key integer NOT NULL,
period integer,
period_index integer,
period_yyyymm integer,
est_idiosyncratic_return_value numeric(30,20) NOT NULL,
CONSTRAINT est_idiosyncratic_return_pk PRIMARY KEY
(est_idiosyncratic_return_key )
)
WITH (
OIDS=FALSE
);
ALTER TABLE estimated_idiosyncratic_return
OWNER TO postgres;

-- Index: estimated_idiosyncratic_return_ws_run_key

-- DROP INDEX estimated_idiosyncratic_return_ws_run_key;

CREATE INDEX estimated_idiosyncratic_return_ws_run_key
ON estimated_idiosyncratic_return
USING btree
(ws_run_key );

-- Index: estimated_idiosyncratic_return_ws_run_key_fund_key

-- DROP INDEX estimated_idiosyncratic_return_ws_run_key_fund_key;

CREATE INDEX estimated_idiosyncratic_return_ws_run_key_fund_key
ON estimated_idiosyncratic_return
USING btree
(ws_run_key , fund_key );