setting for maximum acceptable plan cost?
| От | Jeffrey W. Baker | 
|---|---|
| Тема | setting for maximum acceptable plan cost? | 
| Дата | |
| Msg-id | 1194036567.11267.19.camel@squeak обсуждение исходный текст  | 
		
| Ответы | 
                	
            		Re: setting for maximum acceptable plan cost?
            		
            		 Re: setting for maximum acceptable plan cost?  | 
		
| Список | pgsql-general | 
I was thinking that it might be nice to be able to tell postgres to refuse to execute any plan with an estimated cost above some threshold. For example, earlier today I produced this extremely bogus execution plan with the following top line: Nested Loop Left Join (cost=13920.16..2257575559347.46 rows=3691992705807 width=128) After a call to ANALYZE, the same query gave me: Merge Left Join (cost=16382.02..16853.87 rows=126768 width=59) And runs in 5 seconds. If I had been able to tell pg to reject any plan with cost over, say 10E9, that would have saved my server from half an hour of nested sequential scans. Should I just use statement_timeout as a proxy for this? -jwb
В списке pgsql-general по дате отправления: