Re: New Data Handling Paradigms?

[Chris Albertson <calbertson@LOGICON.COM>]

Peter Mount wrote:


<SNIP>

> This shouldn't be difficult to do, although I don't have the ammount of
> free space yet. I can push about 60 million rows at 100 bytes per row.

The last time I tried to do a perfornence test on Postgres I made
a mistake.  I made a test database so small that the whole thing
got cached in RAM.  I figured that out then I made a lager database but
one of the index files would fit in the system cache.  I don't think
the actual number of rows matters as long as the test "thrashes the
cache"

--
  Chris Albertson

  calbertson@logicon.com                  Voice: 626-351-0089  X127
  Logicon, Pasadena California            Fax:   626-351-0699