Hi! When I execute SELECT min(id) FROM test; PostgreSQL optimizer uses sequential scan for performing the query even if any index on "id" exists. VACUUM ANALYZE just before the query doesn't help. Runtime option to not use sequenatial scans doesn't help. So, I suppose it's a real bug. -- Best regards, Nick mailto:[EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
- [BUGS] carol guinebert
- [BUGS] Vasileiadis Spyros
- [BUGS] Warwick Johnston
- [BUGS] pgsql-bugs
- Re: [BUGS] Tom Lane
- [BUGS] Nome real
- [BUGS] Re: Thomas Lockhart
- [BUGS] IGB.NET
- [BUGS] loganathan p
- [BUGS] Nick Gazaloff
- [BUGS] Nick Gazaloff
- [BUGS] Trurl McByte
- [BUGS] Valery Kocubinsky
- [BUGS] Ana Claudia
- Re: [BUGS] Bruce Momjian
- Re: [BUGS] Stephan Szabo
- [BUGS] Ricardo Caesar Lenzi
- [BUGS] Patricia Anderson
- Re: [BUGS] Bruce Momjian
- [BUGS] Hardeep
- [BUGS] Bhuvan A