| From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
|---|---|
| To: | elrik <elrik-de-melnibone(at)ifrance(dot)com> |
| Cc: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: what do postgresql with view ? |
| Date: | 2004-04-06 22:20:50 |
| Message-ID: | Pine.LNX.4.33.0404061620090.5918-100000@css120.ihs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 31 Mar 2004, elrik wrote:
> 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...
Sounds like you might be wresting with the genetic query optimizer. Try
turning up the geqo theshold and see if things work better.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc G. Fournier | 2004-04-06 22:46:07 | Re: Small suggestion on build script |
| Previous Message | Simon Riggs | 2004-04-06 22:19:21 | Re: Function to kill backend |