11 Jan 2002 Szilva   » (Apprentice)

New disk, new hopes. My 32G disk is almost full, so I had a new 36G (both SCSI). It was more difficult to find the proper screws than to mount it in bash. I do not know why do I need a three days long training course to install something into the new PC houses.

Well, using Linux seems that the MOSIX-patched kernel is not happy neither with ext3 or xfs so I had to use reiser on the new disk. It is not the best choice for PostgreSQL databases, but still prooved to be useful. I uploaded 116 tables, 116*100 rows each and an additional 116*100 rows (alltogether 1,357,200 rows). For such an upload a vacuum should be useful after every few hundred thousand I think. The kernel panicked in the middle of the job, reiser still saved at least half of the data. After vacuum PG was happy with thee rest of the data. Uploading the same stuff into Oracle by sqlload also OK by now (well, that was my first ora job ;). And seems it is as quick as with Postgres. Presently I am testing the upload and trying to load everything into one table ;P

bayes1=# select count(*) from allsd;




(1 row)

Latest blog entries     Older blog entries

New Advogato Features

New HTML Parser: The long-awaited libxml2 based HTML parser code is live. It needs further work but already handles most markup better than the original parser.

Keep up with the latest Advogato features by reading the Advogato status blog.

If you're a C programmer with some spare time, take a look at the mod_virgule project page and help us with one of the tasks on the ToDo list!