| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | Nabil Sayegh <postgresql(at)e-trolley(dot)de> |
| Cc: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: 7.4 dramatically slower than 7.3? |
| Date: | 2004-04-06 16:21:45 |
| Message-ID: | 20040406092109.U37655@megazone.bigpanda.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Tue, 6 Apr 2004, Nabil Sayegh wrote:
> Stephan Szabo wrote:
>
> > One other possibility is that the planning is taking a really long time.
> > How long do explain (non-analyze) on the two systems take? And how many
> > joins are there precisely?
>
> Yeah, that seems to be it.
> It takes ~
> (real) 3.776s on 7.4
> (real) 0.082s on 7.3
> measured with bash/time but shouldn't make a difference
>
> So the plan is actually better but takes much longer to ... plan, right?
Yes. You might want to see if lowering join_collapse_limit helps any, I'd
suggest trying 0 first and then incrementing it.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Manfred Koroschetz | 2004-04-06 18:37:21 | Re: Help for MSSQL "Compute" equivalent in Postgres |
| Previous Message | Nabil Sayegh | 2004-04-06 15:36:21 | Re: 7.4 dramatically slower than 7.3? |