[GENERAL] Do not understand high estimates of index scan vs seq scan

2013-06-20 Thread Antonio Goméz Soto
Hi all, I do not understand why postgreSQL estimates an index scan only half as fast as a seq scan: system=# explain select * from queuelog;QUERY PLAN --- Seq Scan on queuelog (cost=0.00..20530.29

Re: [GENERAL] Do not understand high estimates of index scan vs seq scan

2013-06-20 Thread Jeff Janes
On Thu, Jun 20, 2013 at 6:47 AM, Antonio Goméz Soto antonio.gomez.s...@gmail.com wrote: Hi all, I do not understand why postgreSQL estimates an index scan only half as fast as a seq scan: system=# explain select * from queuelog;QUERY PLAN