Re: Identical Queries

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Rob Schall <rschall(at)callone(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Identical Queries
Date: 2007-03-01 22:23:08
Message-ID: 20070301142004.J53183@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, 1 Mar 2007, Rob Schall wrote:

> There are 4 entries (wanted to make the playing field level for this
> test). There are 2 with true for istf and 2 with false.

Then analyzing might help, because I think it's estimating many more rows
for both cases, and with 2 rows estimated to be returned the nested loop
should seem a lot more attractive than at 900+.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message hatman 2007-03-01 22:28:09 Re: performances with Pentium D
Previous Message Alex Deucher 2007-03-01 22:12:02 Re: strange performance regression between 7.4 and 8.1