Re: performance tuning in large function / transaction
От | Stephan Szabo |
---|---|
Тема | Re: performance tuning in large function / transaction |
Дата | |
Msg-id | 20011216194044.L46323-100000@megazone23.bigpanda.com обсуждение исходный текст |
Ответ на | Re: performance tuning in large function / transaction (MindTerm <mindterm@yahoo.com>) |
Ответы |
Re: performance tuning in large function / transaction
Re: performance tuning in large function / transaction |
Список | 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?
В списке pgsql-sql по дате отправления: