[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