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

[NISHIYAMA Tomoaki]

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 <aeng using 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 using r-project.org
>> https://stat.ethz.ch/mailman/listinfo/r-sig-db
> 
> _______________________________________________
> R-sig-DB mailing list -- R Special Interest Group
> R-sig-DB using r-project.org
> https://stat.ethz.ch/mailman/listinfo/r-sig-db