On Tue, May 6, 2014 at 4:47 PM, Paul Gilbert <pgilbert...@gmail.com> wrote:
> 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. >> > Googling that error message leads to posts about postgresql so its coming from the backend. Almost certainly an error in the SQL query. THK > >> 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 >> >> > _______________________________________________ > R-sig-DB mailing list -- R Special Interest Group > R-sig-DB@r-project.org > https://stat.ethz.ch/mailman/listinfo/r-sig-db > -- http://www.keittlab.org/ [[alternative HTML version deleted]] _______________________________________________ R-sig-DB mailing list -- R Special Interest Group R-sig-DB@r-project.org https://stat.ethz.ch/mailman/listinfo/r-sig-db
