On Fri, 2004-02-06 at 02:44, Hannu Krosing wrote: > Christopher Browne kirjutas N, 05.02.2004 kell 07:32: > > Oops! [EMAIL PROTECTED] (Orion Henry) was seen spray-painting on a wall: > > > Oh... as a side note I'm happy to announce that the 2.6 Linux kernel > > > has more than DOUBLED the speed of all my Postgres queries over the > > > 2.4. =) > > > > I did some heavy-transaction-oriented tests recently on somewhat > > heftier quad-Xeon hardware, and found little difference between 2.4 > > and 2.6, and a small-but-quite-repeatable advantage with FreeBSD 4.9. > > Now, I'm quite sure my load was rather different from yours, but I > > find the claim of doubling of speed rather surprising. > > perhaps you were just IO-bound while he was not ? > > or starving on some locks ?
The queries were across almost 4 gigs of data on a machine with 512 MB of ram. I personally was assuming it was the anticipatory disk scheduler... but alas I don't know why it affected me so much.
signature.asc
Description: This is a digitally signed message part