Re: [BUGS] BUG #6787: Query planner estimates worng costs on nodes

2012-07-31 Thread Tom Lane
gsavi...@gmail.com writes: > It seems the cost assigned to a sequential scan over 120 million records is > too low or, on the other side, the cost assigned to two nested loop over > three indexes is too high. It looks from here like you are measuring a situation where vb_product_readings is fully

[BUGS] BUG #6787: Query planner estimates worng costs on nodes

2012-07-31 Thread gsaviane
The following bug has been logged on the website: Bug reference: 6787 Logged by: Giorgio Saviane Email address: gsavi...@gmail.com PostgreSQL version: 8.4.12 Operating system: Linux Description: Hi, I would submit the explain analayze results of a query with and witho