In information i have:
1. when creating view : PostgreSQL parse the query and stock the tree query.
2. when using : PostgreSQL use this tree like a subselect.
my question : Do PostgreSQL makes an analyse of the resulted tree ?
---(end of
[EMAIL PROTECTED] (elrik) wrote in message news:[EMAIL PROTECTED]...
In information i have:
1. when creating view : PostgreSQL parse the query and stock the tree query.
2. when using : PostgreSQL use this tree like a subselect.
my question : Do PostgreSQL makes an analyse of the resulted
In fact the probleme is when i have more than 11 tables in the query...
Please post the EXPLAIN ANALYZE results of the problematic query, as
well as the definition of any views it uses.
Also, SHOW from_collapse_limit;
---(end of broadcast)---
On 31 Mar 2004, elrik wrote:
[EMAIL PROTECTED] (elrik) wrote in message news:[EMAIL PROTECTED]...
In information i have:
1. when creating view : PostgreSQL parse the query and stock the tree query.
2. when using : PostgreSQL use this tree like a subselect.
my question : Do