[Bizgres-general] statement_cost_limit

[Simon Riggs]

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?

Best Regards, Simon Riggs
-------------- next part --------------
A non-text attachment was scrubbed...
Name: statement_cost_limit.patch
Type: text/x-patch
Size: 2807 bytes
Desc: not available
Url : http://pgfoundry.org/pipermail/bizgres-general/attachments/20060220/20407926/statement_cost_limit.bin