Postgres Pro
Downloads
Home   >   mailing lists

Re: The usual sequential scan, but with LIMIT ! - Mailing list pgsql-performance

From Pierre-Frédéric Caillaud
Subject Re: The usual sequential scan, but with LIMIT !
Date
Msg-id opsdwnjgnecq72hf@musicbox
Whole thread Raw
In response to The usual sequential scan, but with LIMIT !  (Pierre-Frédéric Caillaud<lists@boutiquenumerique.com>)
List pgsql-performance
Tree view 
Update :

select * from apparts where departement=69 order by departement limit 10;

does use an index scan (because of the ORDER BY), even with OFFSET, and
it's a lot faster.

pgsql-performance by date:

Previous
From: Pierre-Frédéric Caillaud
Date:
Subject: The usual sequential scan, but with LIMIT !
Next
From: Dennis Bjorklund
Date:
Subject: Re: The usual sequential scan, but with LIMIT !