Re: performance tuning in large function / transaction

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: MindTerm <mindterm(at)yahoo(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: performance tuning in large function / transaction
Date: 2001-12-14 14:44:47
Message-ID: 20011214064148.J11758-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


On Fri, 14 Dec 2001, MindTerm wrote:

> Hi all,
>
> table :
> application : 220 rows ;
> usermenu : 6055 rows ;

Well, I'd need the other tables involved in the function
too, but to start with, try rewriting the queries in the
function to use EXISTS rather than IN (see the faq), or
bring them into a normal join with the other tables where
possible.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message D'Arcy J.M. Cain 2001-12-14 15:03:39 Re: cidr question
Previous Message MindTerm 2001-12-14 09:06:47 Re: performance tuning in large function / transaction