| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Cyril VELTER" <cyril(dot)velter(at)libertysurf(dot)fr> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Union View Optimization |
| Date: | 2001-11-01 18:45:05 |
| Message-ID: | 22942.1004640305@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-general pgsql-hackers |
"Cyril VELTER" <cyril(dot)velter(at)libertysurf(dot)fr> writes:
> Is there a way for the optimizer to move the view "where" clause in the
> elementary union queries in order to use an index scan instead of the Seq
> scan ?
This is on the "to look at" list. It's not immediately clear to me
whether there are any restrictions on when the system can safely make
such a transformation, nor whether there are cases where it would be
a pessimization rather than an optimization.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christof Petig | 2001-11-02 10:49:03 | recent ECPG 7.1->7.2 incompatibility ( interval('0sec') = syntax error ) |
| Previous Message | Tom Lane | 2001-11-01 18:37:30 | Re: user authentication crash by Erik Luke (20-08-2001; 1.3kb) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-11-01 18:49:00 | Sorry for blocking email |
| Previous Message | Konstantinos Agouros | 2001-11-01 17:17:26 | 7.1.3 on same machine with Solaris 2.6 vs Sol7 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-11-01 18:49:00 | Sorry for blocking email |
| Previous Message | Tom Lane | 2001-11-01 18:37:30 | Re: user authentication crash by Erik Luke (20-08-2001; 1.3kb) |