Re: problem with from_collapse_limit and joined views

From: Markus Schulz <msc(at)antzsystem(dot)de>
To: pgsql-performance(at)postgresql(dot)org
Cc: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
Subject: Re: problem with from_collapse_limit and joined views
Date: 2010-12-04 10:24:02
Message-ID: 201012041124.03154.msc@antzsystem.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Am Freitag, 3. Dezember 2010 schrieb Kevin Grittner:
> Markus Schulz <msc(at)antzsystem(dot)de> wrote:
> > i have a big performance problem
> >
> > [joining two complex views for reporting]
>
> What version of PostgreSQL is this? How is PostgreSQL configured?
> (The postgresql.conf file with all comments removed is good.)

Production System is 8.4 (config attached).
But i've tried 9.0 with same result.

Regards
msc

Attachment Content-Type Size
postgresql.conf text/plain 1.8 KB

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Mathieu De Zutter 2010-12-04 11:56:50 Slow query to get last created row using CURRVAL
Previous Message John Papandriopoulos 2010-12-04 09:20:21 Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT