| From: | Orion Henry <orion(at)trustcommerce(dot)com> |
|---|---|
| To: | Hannu Krosing <hannu(at)tm(dot)ee> |
| Cc: | Christopher Browne <cbbrowne(at)acm(dot)org>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: 7.3 vs 7.4 performance |
| Date: | 2004-02-07 01:03:26 |
| Message-ID: | 1076115806.3377.122.camel@orthanc |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Fri, 2004-02-06 at 02:44, Hannu Krosing wrote:
> Christopher Browne kirjutas N, 05.02.2004 kell 07:32:
> > Oops! orion(at)trustcommerce(dot)com (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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Orion Henry | 2004-02-07 01:49:05 | Re: 7.3 vs 7.4 performance |
| Previous Message | Orion Henry | 2004-02-07 01:02:10 | Re: 7.3 vs 7.4 performance |