> That would be an excellent question to add to the FAQ:
> "How do I estimate the resource requirements for a database?"
I spent some time to create 3GB of sample data (just zeros, about half the
size of the actual data set I have to deal with). I'm currently importing it
into the database. As far as I already can tell: the main index will be
approx 4GB in size. AFAIK, 32bit systems never grant more than 2GB RAM per
process ...
This may take a while, about 20 hours maybe. The partition has approx 10GB, I
can't afford more. Let's hope that this is sufficient.
Since there's so much interest in this, I'll submit a couple of timings as
soon as possible =)
Regards
Daniel
