Re: Bad plan for nested loop + limit - Mailing list pgsql-performance

From Alexander Staubo
Subject Re: Bad plan for nested loop + limit
Date
Msg-id 88daf38c0903300424s365ef753t52e3d0373131a40d@mail.gmail.com
Whole thread Raw
In response to Re: Bad plan for nested loop + limit  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-performance
On Sun, Mar 1, 2009 at 4:32 AM, Robert Haas <robertmhaas@gmail.com> wrote:
> What do you have default_statistics_target set to?  If it's less than
> 100, you should probably raise it to 100 and re-analyze (the default
> value for 8.4 will be 100, but for 8.3 and prior it is 10).

Changing it to 100 fixed the problem. Thanks for alerting me to the
existence of default_statistics_target.

Alexander.

pgsql-performance by date:

Previous
From: Matthew Wakeling
Date:
Subject: Re: Very specialised query
Next
From: Mario Splivalo
Date:
Subject: Forcing seq_scan off for large table joined with tiny table yeilds improved performance