Re: [BUGS] BUG #7510: Very bad costing estimation on gin vs gist with FTS

2012-08-29 Thread Tom Lane
dan...@heroku.com writes: > If one adds a GIN index and does a fresh analyze, the planner still produce > a plan for the GiST index. Because there is no way to disable particular > indexes in a session, it's impossible to quickly experiment with a new > hypothetical situation with only the GIN ind

[BUGS] BUG #7510: Very bad costing estimation on gin vs gist with FTS

2012-08-29 Thread daniel
The following bug has been logged on the website: Bug reference: 7510 Logged by: Daniel Farina Email address: dan...@heroku.com PostgreSQL version: 9.1.4 Operating system: Ubuntu 10.04 Description: Summary: Planner chooses GiST even if GIN is much better. We have a t