Re: Making a tree with "millions and millions" of dynamic nodes - Mailing list pgsql-general

From jisaacks@yahoo.com (John Isaacks)
Subject Re: Making a tree with "millions and millions" of dynamic nodes
Date
Msg-id 8a9a4c2a.0312110703.4fa8d41c@posting.google.com
Whole thread Raw
In response to Making a tree with "millions and millions" of dynamic nodes  (Christian Fowler <google@NOSPAM.gravesweeper.com>)
List 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.

pgsql-general by date:

Previous
From: Patrick Higgins
Date:
Subject: PL/PgSQL composite parameter usage?
Next
From: "Smitha V. Babu"
Date:
Subject: uITRON