Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds

From: Francisco Reyes <lists(at)stringsutils(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Pgsql performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds
Date: 2010-11-08 09:13:35
Message-ID: cone.1289207615.79145.5158.1000@shelca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Robert Haas writes:

> This part looks really strange to me. Here we have a nested loop
> whose outer side is estimated to produce 33 rows and whose outer side
> is estimated to produce 2 rows.

We have retained someone to help us troubleshoot the issue.
Once the issue has been resolved I will make sure to post our
findings.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Marti Raudsepp 2010-11-08 14:23:27 Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
Previous Message shaiju.ck 2010-11-08 06:16:56 Select * is very slow