[Bizgres-general] statement_cost_limit

Mark Kirkwood markir at paradise.net.nz
Mon Feb 20 22:45:01 GMT 2006


Simon Riggs wrote:
> A new parameter that allows the administrator to place sensible limits
> on the size of queries executed. 
> 
> This is useful for ad-hoc SQL access 
> - when a very large table cannot realistically be sorted etc, so
> prevents general users from saying "SELECT * FROM TABLE ORDER BY 1"
> 
> - for preventing poorly coded SQL with missing join conditions from
> causing impossibly huge cartesian joins from tieing up an important
> production system for the weekend etc..
> 
> Use EXPLAIN to find out what to set this to.
> 
> Generally useful?
> 

Yes, sure does look useful to me!


More information about the Bizgres-general mailing list