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 ?

30 Mar 2004 10:05:02 -0800
elrik-de-melnibone@ifrance.com (elrik)
what do postgresql with view ?
elrik-de-melnibone@ifrance.com (elrik) wrote in message news:<762279de.0403301005.502b3cd3@posting.google.com>...
> 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 ?


I can answer by myself : YES !

In fact the probleme is when i have more than 11 tables in the query...

31 Mar 2004 08:58:20 -0800
elrik-de-melnibone@ifrance.com (elrik)
Re: what do postgresql with view ?
> 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;


Tue, 06 Apr 2004 15:04:18 -0400
Rod Taylor <pg@rbt.ca>
Re: what do postgresql with view ?
On 31 Mar 2004, elrik wrote:

> elrik-de-melnibone@ifrance.com (elrik) wrote in message news:<762279de.0403301005.502b3cd3@posting.google.com>...
> > 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 ?
> 
> 
> I can answer by myself : YES !
> 
> In fact the probleme is when i have more than 11 tables in the query...

Sounds like you might be wresting with the genetic query optimizer.  Try 
turning up the geqo theshold and see if things work better.


Tue, 6 Apr 2004 16:20:50 -0600 (MDT)
"scott.marlowe" <scott.marlowe@ihs.com>
Re: what do postgresql with view ?