11 Jan 2002 (updated 11 Jan 2002 at 15:30 UTC)
»
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)