Search Postgresql Archives

Re: query taking much longer since Postgres 8.4 upgrade

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Mar 21, 2011 at 11:32 AM,  <tv@xxxxxxxx> wrote:
>> Incredible!  Setting enable_nestloop off temporarily for the run of this
>> script made it run in less than a minute (had been running in 10 or 11
>> minutes).  I think you have found a solution for many of my slow running
>> scripts that use these same type of joins.  Thanks again.
>> Julie
>
> Nice. Can you post EXPLAIN ANALYZE again, so that we can see why this plan
> was evaluated as as more expensive before disabling nested loops?

well the problem is obvious -- the planner is estimating ~ 250 loops,
when it in fact has to do ~ 60k.  That's a two orders of magnitude
miss.

merlin

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux