Re: [PERFORM] FTS performance issue - planner problem identified (but only partially resolved)

2013-07-29 Thread Stefan Keller
Hi Kevin Well, you're right :-) But my use cases are un-specific "by design" since I'm using FTS as a general purpose function. So I still propose to enhance the planner too as Tom Lane and your colleague suggest based on repeated similar complaints [1]. Yours, Stefan [1] http://www.postgresql

Re: [PERFORM] FTS performance issue - planner problem identified (but only partially resolved)

2013-07-29 Thread Kevin Grittner
Stefan Keller wrote: > Finally, setting random_page_cost to 1 helps also - but I don't > like this setting neither. Well, you should learn to like whichever settings best model your actual costs given your level of caching and your workload.  ;-) FWIW, I have found page costs less volatile and e