OK, I have a better version at:
ftp://candle.pha.pa.us/pub/postgresql/randcost
I have added a null loop which does a dd on a single file without
reading any data, and by netting that loop out of the total computation
and increasing the number of tests, I have gotten the following results
I got somewhat different:
$ ./randcost /usr/local/pgsql/data
Collecting sizing information ...
Running random access timing test ...
Running sequential access timing test ...
Running null loop timing test ...
random test: 13
sequential test: 15
null timing test: 11
random_page_cost = 0.
On Tue, 10 Sep 2002, Bruce Momjian wrote:
> Interesting that random time is increasing, while the others were
> stable. I think this may have to do with other system activity at the
> time of the test.
Actually, the random versus sequential time may also be different
depending on how many proce
> > Here are the proposals for solutioning the "Return proper effected
> > tuple count from complex commands [return]" issue as seen on TODO.
> >
> > Any comments ?... This is obviously open to voting and discussion.
>
> We don't have a whole lot of freedom in this; this area is
> covered by th
> What is the difference
> between a trigger, a rule and an instead rule from a business process
> oriented point of view? I think there is none at all. They are just
> different techniques to do one and the same, implement
> business logic in the database system.
The difference is how other db'
101 - 105 of 105 matches
Mail list logo
