Denis Gasparin <[EMAIL PROTECTED]> writes: > Is it possible that the query planner thinks that is best a sequential scan > when an index on the table is present? Possibly. It all depends on the statistics. You have not shown us the EXPLAIN results obtained after doing VACUUM ANALYZE... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
- Re: [GENERAL] Matthew Hixson
- [GENERAL] kapil c. tilwani
- [GENERAL] Re: Gregory Wood
- Re: [GENERAL] Re: Thalis A. Kalfigopoulos
- [GENERAL] prabakaran
- [GENERAL] rwell
- [GENERAL] Denis Gasparin
- Re: [GENERAL] Denis Gasparin
- Re: [GENERAL] Denis Gasparin
- Re: [GENERAL] Denis Gasparin
- [GENERAL] Tom Lane
- [GENERAL] Daniel Lundqvist
- Re: [GENERAL] Justin Clift
- [GENERAL] Mona
- Re: [GENERAL] patrick keshishian
- Re: [GENERAL] Dave Cramer
- [GENERAL] Daniel E. Fisher
- Re: [GENERAL] Karsten Hilbert
- Re: [GENERAL] Paul Thomas
- [GENERAL] zoop
- [GENERAL] Gregory S. Williamson