Postgres Pro
Downloads
Home   >   mailing lists

Re: problem with from_collapse_limit and joined views - Mailing list pgsql-performance

From Markus Schulz
Subject Re: problem with from_collapse_limit and joined views
Date
Msg-id 201012041124.03154.msc@antzsystem.de
Whole thread Raw
In response to Re: problem with from_collapse_limit and joined views  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-performance
Tree view 
Am Freitag, 3. Dezember 2010 schrieb Kevin Grittner:
> Markus Schulz <msc@antzsystem.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

pgsql-performance by date:

Previous
From: John Papandriopoulos
Date:
Subject: Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT
Next
From: Mathieu De Zutter
Date:
Subject: Slow query to get last created row using CURRVAL