We are running a 3TB scientific database on a 64 Linux machine with 64GB RAM and 6 TB diskspace. The two largest tables contain 400M (500columns and 12B (!) (6columns) records, each roughly 1TB in storage. The queries do not pose problems, except for reading sometimes quite some data. dariuszs wrote:
Hi, Maybe I need a bigger box for what I'm doing. Right now it's 64 bit windows machine with lots of SAS storage and 48GB of memory. I've setup few tables with over 100 million records and about 300 fields in each table, and I'm running counts on those tables at the same time. Could you advise. Thanks. Dariusz.
Stefan Manegold wrote:
On Tue, Jan 27, 2009 at 03:50:02PM -0500, dariuszs wrote:
Hi, Can somebody help me with this one. I was running a very long query, decided to terminate that job. Now when I try to get the client all I see is blinking prompt. How do I get back the sql prompt? Thanks. Dariusz.
- did you terminate only the client or also the server? - is your server still running? if not, you need to restart it. if it is, is it idle or busy? in any case quitting the server and restarting it might be a good idea. note though, that starting the server might take some time, in case it need to reply the write-ahead logs.
(do I recall correctly, that you are using the Nov2008 version of MonetDB (or Nov2008-SP1 or Nov2008-SP2?) on Win32?
Stefan
------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users