[R-sig-DB] RPostgreSQL and memory usage error

[Paul Gilbert]

One possibility is that you are mistakenly doing a query that returns a 
much larger number of records than you are expecting. Try count(*) to 
check how many records you are trying to return.

If the client and server are the same machine, there is a possibility 
that the server is grabbing a lot of memory, maybe for a join or 
something like that. I'm really not very familiar with the memory 
demands of the server. I guess I am not even sure if this message comes 
from the R side of the DBI or is passed back from the server and DBI is 
just the messenger. Others on this list probably know the answer to that.

Paul

On 05/05/2014 01:15 PM, Alan Eng wrote:
> Hi there,
>
> My name is Alan and I work in analytics for a startup in San Francisco. My
> company has been using the RPostgreSQL package as an interface to our
> Postgres DB for the past year but recently an error surfaced that I could
> not find the solution to on Google.
>
> With small or large queries, the error "RS-DBI driver: (could not Retrieve
> the result : ERROR: out of memory DETAIL: Failed on request of size
> 3145728" comes up. The "3145728" seems random because other times I get
> size of 36 or 24.
>
> Thanks in advance for any tips/advice on resolving this issue. Here's some
> info on package versions:
>
> R version 3.0.1 (2013-05-16)
> RPostgreSQL_0.4
> DBI_0.2-7
> sqldf_0.4-7.1
>