>I'm curious to see if Aaron can test his structure on 9.3 with the >original data and WHERE clause and see if the planner still goes for >the >terrible plan. If it does, that would seem like an obvious planner >tweak >to me. I will try to spin up a test 9.3 db and run the same queries to see if this is the case. Least I can do in return for the help. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
- Re: [PERFORM] how to improve perf of 13... Sébastien Lorion
- Re: [PERFORM] how to improve perf of 131MM row ... Claudio Freire
- Re: [PERFORM] how to improve perf of 131MM ... AJ Weber
- Re: [PERFORM] how to improve perf of 13... Claudio Freire
- Re: [PERFORM] how to improve perf of 13... AJ Weber
- Re: [PERFORM] how to improve perf of 13... Claudio Freire
- Re: [PERFORM] how to improve perf of 13... Shaun Thomas
- Re: [PERFORM] how to improve perf of 13... AJ Weber
- Re: [PERFORM] how to improve perf of 131MM row table? Jeff Janes
- Re: [PERFORM] how to improve perf of 131MM row tabl... Shaun Thomas
- Re: [PERFORM] how to improve perf of 131MM row ... Aaron Weber
- Re: [PERFORM] how to improve perf of 131MM row tabl... Aaron Weber