> someone else on this list may be able to give you a ballpark estimate
> of how much RAM this merge would require.
I don't have an absolute estimate, but try data.table::merge, as it needs
less
working memory than base::merge.
20 million rows of 5 columns isn't beyond 32bit :
(1*4 + 4*8)*197
Janet Choate-2 wrote:
>
> Thanx for clarification on stating my problem, Charlie.
>
> I am attempting to merge to files, i.e.:
> hi39 = merge(comb[,c("hillID","geo")], hi.h39, by=c("hillID"))
>
> if this is relevant or helps to explain:
> the file 'comb' is 3 columns and 1127 rows
> the file '
Thanx for clarification on stating my problem, Charlie.
I am attempting to merge to files, i.e.:
hi39 = merge(comb[,c("hillID","geo")], hi.h39, by=c("hillID"))
if this is relevant or helps to explain:
the file 'comb' is 3 columns and 1127 rows
the file 'hi.h39' is 5 columns and 19758564 rows
i s
Janet Choate-2 wrote:
>
> Hi R community,
> i have what appears to be a memory allocation problem:
>
> R(51150) malloc: *** mmap(size=158068736) failed (error code=12)
> *** error: can't allocate region
> *** set a breakpoint in malloc_error_break to debug
>
> can anyone tell me how to increas
Hi R community,
i have what appears to be a memory allocation problem:
R(51150) malloc: *** mmap(size=158068736) failed (error code=12)
*** error: can't allocate region
*** set a breakpoint in malloc_error_break to debug
can anyone tell me how to increase the memory size for R on mac os X?
thank
Try the RpgSQL package and see if you get the same problem.
On Fri, Mar 5, 2010 at 10:08 PM, Peter wrote:
> hi,
>
> I have been attempting to run this script and am getting some strange
> results. The script connects to a database and retrieves a series of tables,
> using sequential sql statement
Probably a bug in the RdbiPgSQL package you are using. Please ciontact
its maintainer and send a reproducible example.
Best,
Uwe Ligges
On 06.03.2010 04:08, Peter wrote:
hi,
I have been attempting to run this script and am getting some strange
results. The script connects to a database and r
hi,
I have been attempting to run this script and am getting some strange
results. The script connects to a database and retrieves a series of
tables, using sequential sql statements. I have tested all of the sql
statements in the PostGreSQL terminal and they all return the desired
results. I
8 matches
Mail list logo
