Re: AW: Berkeley DB... - Mailing list pgsql-hackers

From Michael A. Olson
Subject Re: AW: Berkeley DB...
Date
Msg-id 200005251443.HAA55946@triplerock.olsons.net
Whole thread Raw
In response to AW: Berkeley DB...  (Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>)
List 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



pgsql-hackers by date:

Previous
From: "Mikheev, Vadim"
Date:
Subject: RE: More Performance
Next
From: Tom Lane
Date:
Subject: Re: AW: AW: More Performance