Re: [PERFORM] Views With Unions

Christopher Browne <[EMAIL PROTECTED]> writes: > The DOMAIN case I mentioned the other day had something odd going on > that LOST the type information associated with the domain. Albeit > that was on 7.3, whereas the changes in DOMAIN functionality that make > them meaningfully useful come in 7.4.

Re: [PERFORM] Views With Unions

Stephan Szabo <[EMAIL PROTECTED]> writes: > On Fri, 1 Aug 2003, Christopher Browne wrote: >> Stephan Szabo said: >> > What version are you using? In 7.3 and up it should be willing to >> > consider moving the clause down, unless there's something like a type >> > mismatch (because in that case it

Re: [PERFORM] Views With Unions

On Fri, 1 Aug 2003, Christopher Browne wrote: > Stephan Szabo said: > > > > > > What version are you using? In 7.3 and up it should be willing to > > consider moving the clause down, unless there's something like a type > > mismatch (because in that case it may not be equivalent without a bunch >

Re: [PERFORM] Views With Unions

Stephan Szabo said: > > On Thu, 31 Jul 2003, Christopher Browne wrote: > >> select * from log_table where request_time between 'june 11 2003' >> and >>'june 12 2003'; >> >> returns a plan: >> Subquery Scan log_table (cost=0.00..10950.26 rows=1

Re: [PERFORM] Views With Unions

Stephan Szabo wrote: On Thu, 31 Jul 2003, Christopher Browne wrote: select * from log_table where request_time between 'june 11 2003' and 'june 12 2003'; returns a plan: Subquery Scan log_table (cost=0.00..10950.26 rows=177126 width=314) ->

Re: [PERFORM] Views With Unions

On Thu, 31 Jul 2003, Christopher Browne wrote: > select * from log_table where request_time between 'june 11 2003' and >'june 12 2003'; > > returns a plan: > Subquery Scan log_table (cost=0.00..10950.26 rows=177126 width=314) > -> Append

[PERFORM] Views With Unions

This is stepping back quite a while; let me point people to the thread of 2003-02 where Mariusz Czu\x{0142}ada <[EMAIL PROTECTED]> was looking for a way of optimizing a VIEW that was a UNION. The subject has come up a few tim