"Michael Richards" <[EMAIL PROTECTED]> writes:
> [ a severely incomplete problem description ]
Table schema? Full text of the query?
> It has one index defined on:
> Index "formdata_pkey"
> Attribute | Type
> ---+-
> formid| integer
> occid | integer
> userid
On Wed, 23 May 2001, Michael Richards wrote:
> Finally, I'm planning on moving this to 7.2 and converting all the
> joins to use outer joins. Will there be a significant penalty in
> performance running outer joins?
Why are you planning on using outer joins? Yes there is a performance penalty
be
Ok, I've built the most insane query ever. It joins 11 tables, most
of which are the same table, just extracting different values. Here
is the query plan:
Nested Loop (cost=0.00..5011.89 rows=1 width=156)
-> Nested Loop (cost=0.00..4191.82 rows=1 width=140)
-> Nested Loop (cost=0.