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;

count

--------

500500

(1 row)