Re: [HACKERS] [SQL] Index of a table is not used (in any case)

Hello Tom! Tom Lane wrote: > > Reiner Dassing <[EMAIL PROTECTED]> writes: > > explain select * from wetter order by epoche desc; > > NOTICE: QUERY PLAN: > > > Index Scan Backward using wetter_epoche_idx on wetter > > (cost=0.00..3216018.59 rows=2034 width=16) > > > explain select * from w

Re: [HACKERS] [SQL] Index of a table is not used (in any case)

Reiner Dassing <[EMAIL PROTECTED]> writes: > explain select * from wetter order by epoche desc; > NOTICE: QUERY PLAN: > Index Scan Backward using wetter_epoche_idx on wetter > (cost=0.00..3216018.59 rows=2034 width=16) > explain select * from wetter where epoche between '1970-01-01' an