Re: performance tuning in large function / transaction

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Stephan Szabo" <sszabo(at)megazone23(dot)bigpanda(dot)com>, "MindTerm" <mindterm(at)yahoo(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: performance tuning in large function / transaction
Date: 2001-12-17 04:06:14
Message-ID: GNELIHDDFBOCMGBFGEFOIENDCAAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> As a note, does rewriting the queries in the function
> to use exists rather than in help any?

Is it true that the IN command is implemented sort of as a linked list
linear time search? Is there any plan for a super-fast implementation of
'IN'?

Chris

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2001-12-17 05:37:52 Re: temp tables versus the global sql area
Previous Message Stephan Szabo 2001-12-17 03:41:21 Re: performance tuning in large function / transaction