Hi, The version 0.4 of RPostgreSQL is known to have memory leak issues, which at least in part was fixed in the latest svn branch. https://code.google.com/p/rpostgresql/issues/detail?id=57 If you have run for a long time on a low memory computer, they might hurt you.
For the release of the fixed version, we need to change the tests structure so that the output on a machine with and without the DB setup will not be too much different and clearly understandable to persuade CRAN maintainers. The part "ERROR: out of memory DETAIL: Failed on request of size 3145728", came from the libpq function call. -- Tomoaki NISHIYAMA Advanced Science Research Center, Kanazawa University, 13-1 Takara-machi, Kanazawa, 920-0934, Japan On 2014/05/08, at 2:40, Neil Tiffin wrote: > Alan, > > Adding to what Paul said, we would need some more info in order to help you. > The best would be sample tables, data, and queries that reproduces the > problem. If the problem is based on a large data set, we can generate data > if we know how to make the problem happen. > > Regards, > > Neil > > On May 5, 2014, at 12:15 PM, Alan Eng <a...@stitchfix.com> 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 >> >> -- >> Alan Eng >> Analytics Engineer and Part-Time Receptionist >> *Stitch Fix* >> >> [[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 > > _______________________________________________ > R-sig-DB mailing list -- R Special Interest Group > R-sig-DB@r-project.org > https://stat.ethz.ch/mailman/listinfo/r-sig-db _______________________________________________ R-sig-DB mailing list -- R Special Interest Group R-sig-DB@r-project.org https://stat.ethz.ch/mailman/listinfo/r-sig-db
