Postgres Pro
Downloads
Home   >   mailing lists

Re: Indexes slower when used in decending vs. ascending order? - Mailing list pgsql-novice

From Tom Lane
Subject Re: Indexes slower when used in decending vs. ascending order?
Date
Msg-id 13189.1144811368@sss.pgh.pa.us
Whole thread Raw
In response to Re: Indexes slower when used in decending vs. ascending order?  ("Alasdair Young" <ayoung@vigilos.com>)
Responses Re: Indexes slower when used in decending vs. ascending  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-novice
Tree view 
"Alasdair Young" <ayoung@vigilos.com> writes:
> (Now I just need to get Postgres 8.0 running on a RedHat 7.2/7.3 box :)

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).

If you want something that was current last year and is probably pretty
stable now, PG 8.0.x on Fedora Core 4 would be a good bet.  Personally
I'd recommend PG 8.1.x on FC5 if you are just looking at deploying now.
It'll be much more maintainable a year or two out.

            regards, tom lane

pgsql-novice by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: advice on setting up schema sought
Next
From: "A. Kretschmer"
Date:
Subject: Re: How to query for Interval