Re: Creating tons of tables to support a query - Mailing list pgsql-general

On Sun, 8 Sep 2002, Jan Ploski wrote:

> I am in particular wondering, why an index on message(sectionID, dateSent)
> does not make these queries comparably fast:
>
>     select msgnum from message where
>         sectionID = ? and
>         dateSent > ?
>         order by dateSent
>         limit 1;

I don't think that'll use an index on (sectionID, dateSent) for the sort
step.  I think an index on (dateSent,sectionID) might be, however.