[GENERAL] index being ignored for "limit n" queries

--- Sort (cost=125293.11..125370.58 rows=30986 width=33) Sort Key: received -> Index Scan using pakiety_stid_measured_idx on pakiety (cost=0.00..122474.14 rows=30986 width=33) Index Cond

Re: [GENERAL] index being ignored for "limit n" queries

elect * from pakiety where stid = 234::smallint > order by stid desc, received desc > limit 1; Thanks. It works. And the speedup was from 2 minutes 32.13 seconds to 0.69 seconds (in a worst case for the previous scenario). Thanks again for your help. Piotr Sulecki. ---(end o