Re: what do postgresql with view ?

From: elrik-de-melnibone(at)ifrance(dot)com (elrik)
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: what do postgresql with view ?
Date: 2004-03-31 16:58:20
Message-ID: 762279de.0403310858.1b77b19c@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

elrik-de-melnibone(at)ifrance(dot)com (elrik) wrote in message news:<762279de(dot)0403301005(dot)502b3cd3(at)posting(dot)google(dot)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...

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mooney, Ryan 2004-03-31 18:08:26 Re: Large DB
Previous Message Tom Lane 2004-03-31 16:35:14 Re: Update on PITR