Postgres Pro
Downloads
Home   >   mailing lists

Re: performance tuning in large function / transaction - Mailing list pgsql-sql

From Christopher Kings-Lynne
Subject Re: performance tuning in large function / transaction
Date
Msg-id GNELIHDDFBOCMGBFGEFOIENDCAAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: performance tuning in large function / transaction  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: performance tuning in large function / transaction
Re: performance tuning in large function / transaction
List pgsql-sql
Tree view 
> 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

pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: persistent connections, AOLserver (Was: maybe Offtopic :
Next
From: Bruce Momjian
Date:
Subject: Re: temp tables versus the global sql area