search

rcconsult / rpostgresql

Automatically exported from code.google.com/p/rpostgresql
0 stars 0 forks source link

out of memory error #46

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1.query <- "select * from ratings"
2.drv <- dbDriver("PostgreSQL")
3.rating.ff <- read.dbi.ffdf(query = query, 
                           dbConnect.args=list(drv,user="postgres",
                                               password="mypassword"),
                           verbose = TRUE)

What is the expected output? What do you see instead?
There is no Output

What version of the product are you using? On what operating system?
R 2.15.2 in Ubuntu-Linux

Please provide any additional information below.

The error I get:

`Error en postgresqlExecStatement(conn, statement, ...) : 
     RS-DBI driver: (could not Retrieve the result : 
     out of memory for query result)`

If I select 10 million rows from the table ratings I don't have a problem, but 
with more I have a problem.

Original issue reported on code.google.com by liz.neco...@gmail.com on 12 Feb 2013 at 5:26

GoogleCodeExporter commented 9 years ago 
The `read.dbi.ffdf` function is from, I think, part of the ff package. 

Hence this is not an issue in RPostgreSQL.

Lastly, if it works with 10 million obs, shouldn't you simply constrain the 
result set, or get a bigger machine?

Original comment by dirk.eddelbuettel on 12 Feb 2013 at 11:12