Alle 15:07, mercoledì 19 ottobre 2005, Richard Huxton ha scritto: > Vittorio wrote: > > In my Pentium 4 box 2GHz with 256 MB of RAM I run a pg server 8.0.3 > > under netbsd 2.0.2 in which among other tables there's a "huge" table > > letture02 made of 657,000 records and 98 numerical columns. > > > > Using psql > > and the "heavy" view letture24btnondom (see below) I face the following > > fatal error: > > .......... > > # select * from letture24btnondom ; > > out of > > memory for query result > > How many rows does this return? All 657,000 records > How much memory does psql take up when it reports this? How could I know that amount of memory? > Do you have any memory limits defined for the user doing the query? No that I'm aware of. Could you please specify this point better? Ciao Vittorio > Can you get it to work with something like LIMIT 10 added to the query? > What about LIMIT 50,100,200 etc? > > > Now, it happens that I pg_dumped > > the database from an original ** freebsd ** installation on another > > older pc (pentium 3 128 MB) where ** under psql I set up the same query > > and ran it successfully many times. > > Besides, via ODBC I can open as a > > table the letture24btnondom view without any problems. > > I'd guess ODBC is using a cursor, so you'll only get a few rows at a > time. With psql, it'll fetch all the rows at once. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
