Re: Indexes slower when used in decending vs. ascending order?

From: "Alasdair Young" <ayoung(at)vigilos(dot)com>
To: "Steve Crawford" <scrawford(at)pinpointresearch(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Indexes slower when used in decending vs. ascending order?
Date: 2006-04-12 18:15:40
Message-ID: 63AA0ECDAF84504CBB44C3655EE241F920BABF@tonga.domain.vigilos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I'm basically stuck with that as well: we run a custom kernel and a
stack of drivers that have no support past 7.2 (at least presently) so
it looks like I'll just need to work out a way of getting 8.0 to compile
on rh7.2 (or patching postgres 7.3 with the bugfix and recompiling :)

None of those look like fun, so this issue will probably be added to our
stack of "reasons to upgrade to FC5"

:)

- alasdair

-----Original Message-----
From: Steve Crawford [mailto:scrawford(at)pinpointresearch(dot)com]
Sent: Wednesday, April 12, 2006 9:43 AM
To: Tom Lane
Cc: Alasdair Young; pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Indexes slower when used in decending vs.
ascending order?

> Um ... I work for Red Hat, so I think I have to slip you the bad news
> twice today: no sane person would still be running that OS version
> either. 7.2 was obsolete about the time I went to work at Red Hat (in

> 2001).

Sadly, some users are stuck. For instance if you have Dialogic D240SC/T1
Rev 1 cards then the latest drivers you can get are the 5.x and they are
very picky about kernel versions, streams libs, etc.

If you want to build a supported system, you must start with Red Hat
7.2/7.3 and must, among other detailed steps, apply specific kernel
patches. Or you can go through a similar set of steps on Windows. I'll
take Linux - even an old version.

Fortunately I have it on authority of an Intel employee that they will
be open-sourcing the Dialogic drivers sometime in the next year so over
time this problem will probably disappear.

Cheers,
Steve

Browse pgsql-novice by date

  From Date Subject
Next Message E. Matthew Finnin 2006-04-12 18:52:37 The COPY command and csv files
Previous Message Steve Crawford 2006-04-12 16:43:14 Re: Indexes slower when used in decending vs. ascending