Re: Join Query Perfomance Issue

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Thomas Zaksek" <zaksek(at)ptt(dot)uni-due(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Join Query Perfomance Issue
Date: 2008-02-11 21:38:06
Message-ID: dcc563d10802111338m43a11630k37b29b21b8965df6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Correction:

> turning off nested loops for that one. But don't turn off nested
> queries universally, they are still a good choice for smaller amounts
> of data.

queries should be loops up there...

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Chris Kratz 2008-02-11 22:24:33 mis-estimate in nested query causes slow runtimes
Previous Message Scott Marlowe 2008-02-11 21:37:34 Re: Join Query Perfomance Issue