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

Venks,

Number of columns is limited only by disk space.  I
have columns which are approx 2GB on disk but I
believe column size is limited to the maximum size of
a file in your given file system, or maybe it is 2GB.

The developers are authority on max column size.

Colin

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

> Colin,
>
> Do you know the size of each row? I have a table
> with 50 columns and could
> grow to 100 columns for our testing. Does this
> matter?
>
>
> 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
> > >
> >
> >
>