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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> wrote: > > > > On 64bit I have two large tables with 49M and 250M > > rows respectively. > > > > > > --- Venks <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 > > > > > [email protected] > > > > > > > > > > > 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: > > > [EMAIL PROTECTED] > > > > > > > > > > > ------------------------------------------------------------------------- > > > 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 > > > [email protected] > > > > > > https://lists.sourceforge.net/lists/listinfo/monetdb-users > > > > > > > > ------------------------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-users
