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