[R] R data import problems

Ulf Mehlig umehlig at uni-bremen.de
Thu Nov 19 21:18:54 CET 1998

Excuse me, if the following is FAQ or nonsense, I'm new to R (and the

After trying to import a textfile of 184897 Bytes, R (v0.63.0 on Linux
2.0.35/DLD 5.4) gives the following error message:

  > read.table ("db.out")
  Error: heap memory (1953 Kb) exhausted [needed 150 Kb more]

Is there a possibility to increase heap size to import larger files?
Files up to 100 k are imported correctly. The file contains a single
column with a floating point value on each row.

Second question: Is it possible to construct an extension that
facilitates the import of data from databases, e.g. postgresql? (or
does it already exist?)

I have something like 

  > DataF <- read.fromDB ("select aaa, bbb from data", dbURL)

in mind, given that dbURL is the URL of a database accessible over
jdbc, odbc and alike, for example? (a separate connect-to-db-function
to handle database access/connect is more realistic, of course). There
would have to be an interface which connects to the db, executes the
query by passing the sql statement ("select ..."), and finally
delivers the output to R (or gives an error message, if necessary).

Many thanks for your attention,

 %%%%%            Ulf Mehlig              <umehlig at zmt.uni-bremen.de>
   %%%%!%%%       Projekt "MADAM"         <umehlig at uni-bremen.de>
%%%% %!% %%%%     ----------------------------------------------------
 ---| %%%         MADAM:  MAngrove    |  Center for Tropical Marine
    ||--%!%              Dynamics     |  Biology
    ||                  And           |  Fahrenheitstrasse 1
 _ /||\_/\_            Management     |  
/  /    \  \ ~~~~~~~~~~~~~~~~~        |  28359 Bremen/Germany
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch

More information about the R-help mailing list