On 3/16/06, Daniel Franke <[EMAIL PROTECTED]> wrote: > > > 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.
Import data without indexes, then add then when the import is complete. It's much faster. > > Since there's so much interest in this, I'll submit a couple of timings as > soon as possible =) Thanks!
