Re: Identical Queries - Mailing list pgsql-performance

From Stephan Szabo
Subject Re: Identical Queries
Date
Msg-id 20070301142004.J53183@megazone.bigpanda.com
Whole thread Raw
In response to Re: Identical Queries  (Rob Schall <rschall@callone.net>)
List 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+.

pgsql-performance by date:

Previous
From: "Alex Deucher"
Date:
Subject: Re: strange performance regression between 7.4 and 8.1
Next
From: "Craig A. James"
Date:
Subject: Re: Identical Queries