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