With --nightly=stable compiled on 2007-01-21 this problem still seems
to occur. We don't have quite as much data imported into the system as
we did last night but it seems to be using a lot of files again. It
hasn't crashed yet, but we're not past the point where SR5 crashed.
$ du -sh /data/db/monetdb
2.6G /data/db/monetdb
$ find /data/db/monetdb|wc -l
285477
On Jan 21, 2008 12:46 AM, Bob Ippolito
We've started doing a big import of data into SR5 and I've noticed that it's creating *A LOT* of files. So far we've got about 620k files for 6.7 GB of bat. I expect that a full import should have at least 20 times what's imported so far. It seems that loading data is relatively slow compared to PostgreSQL (we're using COPY) and I'm guessing it's due to all of these files. Right now we're using ext3 on amd64 ubuntu linux. Should we be looking at other platforms?
-bob