Victor Wagner <[EMAIL PROTECTED]> writes:
> As far as I understand, following three queries are exactly equivalent:
Same results, but the second two constrain the planner's choice of join
order. See
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/explicit-joins.html
Whether this is
On Wed, 3 Apr 2002, Tom Lane wrote:
>
> I'm confused. Your examples show the planner correctly estimating the
> indexscan as much cheaper than the seqscan.
>...
> Cut-and-paste mistake here somewhere, perhaps? The plan refers to fact
> not fact_by_dat.
My apologies... It was indeed doing the
As far as I understand, following three queries are exactly equivalent:
select item.item_id, item.title, author.email
from item, author, item_link
where
item.item_id=author.item_id and item_link.active=item.item_id and
item_link.linktype_id='MODERATES' and
it
