Re: query taking much longer since Postgres 8.4 upgrade

From: tv(at)fuzzy(dot)cz
To: "Davenport, Julie" <JDavenport(at)ctcd(dot)edu>
Cc: "Merlin Moncure" <mmoncure(at)gmail(dot)com>, "Tomas Vondra" <tv(at)fuzzy(dot)cz>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: query taking much longer since Postgres 8.4 upgrade
Date: 2011-03-21 16:32:40
Message-ID: 65169dfe4c8914b7fdf5cdef8c876067.squirrel@sq.gransy.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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?

regards
Tomas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2011-03-21 16:49:39 Re: query taking much longer since Postgres 8.4 upgrade
Previous Message Vick Khera 2011-03-21 16:30:44 Re: Fw: slony- No index found