Re: Making a tree with "millions and millions" of dynamic nodes

From: jisaacks(at)yahoo(dot)com (John Isaacks)
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Making a tree with "millions and millions" of dynamic nodes
Date: 2003-12-11 15:03:40
Message-ID: 8a9a4c2a.0312110703.4fa8d41c@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> >
> > We did it with C++ and a memory mapped file for persistence.
> > We had to use a 64bit cpu and 12G of RAM.
>
> Wow! That's only 300 bytes of RAM for every 10 digit phone number!

We didn't use all of that, last time I checked it was using apx 4G of
RAM,

We had to plan for every possible USA phone number being ported.
The overhead or memory requirements of indexing goes down as more
numbers are placed in the system.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2003-12-11 15:11:17 Re: Storing Snapshot Data
Previous Message Greenwich Support 2003-12-11 15:02:41 Weird Problem With PostgreSQL 7.3.1 and VB.Net Datagrid