Re: Oddity with view

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jim 'Decibel!' Nasby" <jnasby(at)cashnetusa(dot)com>
Cc: postgresql performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Oddity with view
Date: 2008-11-10 13:06:52
Message-ID: 3128.1226322412@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Jim 'Decibel!' Nasby" <jnasby(at)cashnetusa(dot)com> writes:
> loan_tasks effectively does SELECT * FROM loan_tasks_committed UNION
> ALL SELECT * FROM loan_tasks_pending;.

You seem to have neglected to mention a join or two.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Lutischán Ferenc 2008-11-10 16:19:05 Re: Improve Seq scan performance
Previous Message Craig Ringer 2008-11-10 08:41:03 Re: Improve Seq scan performance