Re: [PERFORM] Bad plan for nested loop + limit

2009-02-27 Thread Robert Haas
On Fri, Feb 27, 2009 at 3:18 PM, Alexander Staubo wrote: > On Sun, Feb 15, 2009 at 5:45 PM, Alexander Staubo wrote: >> On Sun, Feb 15, 2009 at 5:29 AM, David Wilson >> wrote: >>> On Sat, Feb 14, 2009 at 5:25 PM, Alexander Staubo wrote: Output from "explain analyze":  Limit

Re: [PERFORM] Bad plan for nested loop + limit

2009-02-27 Thread Alexander Staubo
On Sun, Feb 15, 2009 at 5:45 PM, Alexander Staubo wrote: > On Sun, Feb 15, 2009 at 5:29 AM, David Wilson > wrote: >> On Sat, Feb 14, 2009 at 5:25 PM, Alexander Staubo wrote: >>> >>> Output from "explain analyze": >>> >>>  Limit  (cost=0.00..973.63 rows=4 width=48) (actual >>> time=61.554..4039.