Re: Query on view radically slower than query on underlying table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Craig James <craig_james(at)emolecules(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query on view radically slower than query on underlying table
Date: 2011-02-28 18:57:36
Message-ID: 27415.1298919456@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Craig James <craig_james(at)emolecules(dot)com> writes:
> My guess (and it's just a wild guess) is that the "left join" is
> forcing a sequence scan or something.

No, that's forcing the other join to be done in toto because it can't
reorder the left join and regular join.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Haas 2011-02-28 19:04:53 Re: Bad query plan when the wrong data type is used
Previous Message Marc Cousin 2011-02-28 18:47:46 Re: inheritance: planning time vs children number vs column number