Horton

Re: AW: Berkeley DB...

Michael A. Olson <mao@sleepycat.com>

View thread
From: "Michael A. Olson" <mao@sleepycat.com>
To: Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>
Cc: "'pgsql-hackers@postgreSQL.org'" <pgsql-hackers@postgreSQL.org>
Date: 2000-05-25T14:41:08Z
Lists: pgsql-hackers 
At 12:59 PM 5/25/00 +0200, Zeugswetter Andreas SB wrote:

> Wow, that sounds darn slow. Speed of a seq scan on one CPU, 
> one disk should give you more like 19000 rows/s with a small record size.
> Of course you are probably talking about random fetch order here,
> but we need fast seq scans too.

The test was random reads on a 250GB database.  I don't have a
similar characterization for sequential scans off the top of my
head.
					mike