Mark Stosberg <[EMAIL PROTECTED]> writes:
> I'm not skilled enough at reading the "Explain Analzyze" output to
> understand what the primary problem is.
The problem is the repeated execution of the subquery in the SELECT
list; that's taking over 683 of the 686 seconds:
> SubP
I should have mentioned in the last post that PostgreSQL 8.2.9 is in
use. I could upgrade to 8.3.x if that is expected to help performance in
this case.
Mark
On Sun, 2008-07-06 at 16:23 -0400, Mark Stosberg wrote:
> Hello,
>
> I could use some help figuring out how to speed up a query. Belo
Hello,
I could use some help figuring out how to speed up a query. Below is the
SQL and query plan for a common SELECT done by the open source
eGroupware project.
Now that there are about 16,000 rows in egw_infolog and 32,000 in
egw_infolog_extra, the below query takes about 6 minutes to finish
