Re: How to speed up min/max(id) in 50M rows table? - Mailing list pgsql-performance

From Tom Lane
Subject Re: How to speed up min/max(id) in 50M rows table?
Date
Msg-id 6275.1192229463@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to speed up min/max(id) in 50M rows table?  (henk de wit <henk53602@hotmail.com>)
Responses Re: How to speed up min/max(id) in 50M rows table?
Re: How to speed up min/max(id) in 50M rows table?
List pgsql-performance
henk de wit <henk53602@hotmail.com> writes:
> I see, that sounds very interesting too. As you might have noticed, I'm not=
>  an expert on this field but I'm trying to learn. I was under the impressio=
> n that the last few incarnations of postgresql automatically combined singl=
> e column indexes for cases where a multi-column index would be needed in ea=
> rlier releases.

It's possible to combine independent indexes for resolving AND-type
queries, but the combination process does not preserve ordering, so
it's useless for this type of situation.

            regards, tom lane

pgsql-performance by date:

Previous
From: henk de wit
Date:
Subject: Re: How to speed up min/max(id) in 50M rows table?
Next
From: henk de wit
Date:
Subject: Re: How to speed up min/max(id) in 50M rows table?