Re: performance tuning in large function / transaction
Stephan Szabo <sszabo@megazone23.bigpanda.com>
From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: MindTerm <mindterm@yahoo.com>
Cc: <pgsql-sql@postgresql.org>
Date: 2001-12-17T03:41:21Z
Lists: pgsql-sql
> --- Stephan Szabo <sszabo@megazone23.bigpanda.com> > wrote: > > > > 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. As a note, does rewriting the queries in the function to use exists rather than in help any?