On 4/25/07, Colin Foss <cgfoss@yahoo.com> wrote:

On 64bit I have two large tables with 49M and 250M
rows respectively.

--- Venks < venkatesh.mantha@gmail.com> wrote:

> Thanks very much for your reply confirming what I
> understood based on
> MonetDB architecture. Please allow me another
> follow-up question
>
> Will there be an issue on a 64 bit system? Is there
> an algorithm/logic that
> I can use to identify the maximum number rows that I
> can load in one table
> based on the size of the row?
>
> Regards,
>
> - Venkatesh
>
>
> On 4/25/07, Niels Nes <Niels.Nes@cwi.nl> wrote:
> >
> > On Tue, Apr 24, 2007 at 09:27:13PM -0400, Venks
> wrote:
> > >
> > >    Hi,
> > >
> > >
> > >
> > >    Is there any relation between CPU, RAM and
> the amount of data that
> > >    can be loaded into a MonetDB database?
> > >
> > >
> > >
> > >    I am trying to load 13.4 million rows of data
> and I am getting
> > >    "Segmentation Fault" on a Linux box running
> on 32 bit CPU with 4GB
> > >    RAM.
> > >
> > >
> > >
> > >    I had similar issues on a Windows box too?
> > >
> > Yes there are relations between the 'addressable'
> memory and the
> > amount of data MonetDB can handle. With a 32 bit
> system your adress
> > space is at best 4G. So if your records are larger
> than about 320 bytes
> > 13.4 Million rows cannot fit.
> >
> > Niels
> > >
> > >
> > >    Thanks,
> > >
> > >
> > >
> > >    - Venkatesh
> >
> > >
> >
>
-------------------------------------------------------------------------
> > > This SF.net email is sponsored by DB2 Express
> > > Download DB2 Express C - the FREE version of DB2
> express and take
> > > control of your XML. No limits. Just data. Click
> to get it now.
> > > http://sourceforge.net/powerbar/db2/
> > > _______________________________________________
> > > MonetDB-users mailing list
> > > MonetDB-users@lists.sourceforge.net
> > >
>
https://lists.sourceforge.net/lists/listinfo/monetdb-users
> >
> >
> > --
> >
> > Niels Nes, Centre for Mathematics and Computer
> Science (CWI)
> > Kruislaan 413, 1098 SJ Amsterdam, The Netherlands
> > room C0.02,  phone ++31 20 592-4098, fax ++31 20
> 592-4312
> > url: http://www.cwi.nl/~niels    e-mail:
> Niels.Nes@cwi.nl
> >
> >
-------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2
> express and take
> control of your XML. No limits. Just data. Click to
> get it now.
> http://sourceforge.net/powerbar/db2/ >
_______________________________________________
> MonetDB-users mailing list
> MonetDB-users@lists.sourceforge.net
>
https://lists.sourceforge.net/lists/listinfo/monetdb-users
>