Postgres Pro
Downloads
Home   >   mailing lists

Re: join to view over custom aggregate seems like it should be faster - Mailing list pgsql-performance

From Tom Lane
Subject Re: join to view over custom aggregate seems like it should be faster
Date
Msg-id 10651.1176152866@sss.pgh.pa.us
Whole thread Raw
In response to join to view over custom aggregate seems like it should be faster  ("Merlin Moncure" <mmoncure@gmail.com>)
Responses Re: join to view over custom aggregate seems like it should be faster  ("Merlin Moncure" <mmoncure@gmail.com>)
Re: join to view over custom aggregate seems like it should be faster  ("Merlin Moncure" <mmoncure@gmail.com>)
List pgsql-performance
Tree view 
"Merlin Moncure" <mmoncure@gmail.com> writes:
> I have an odd performance issue on 8.2 that I'd thought I'd document
> here.  I have a workaround, but I'm if there is something that I'm not
> seeing.

It's hard to comment on this without seeing the full details of the view
and tables.  I'm wondering where the SubPlans are coming from, for instance.

            regards, tom lane

pgsql-performance by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Please humor me ...
Next
From: "Merlin Moncure"
Date:
Subject: Re: how to efficiently update tuple in many-to-many relationship?