Re: [GENERAL] Optimize query: time of "single * IN(many)" > time of "many *

2004-01-09 Thread Paul Janssen
Tom Lane writes: Paul Janssen writes: Can anyone help me out with the following situation: (a) a single query with 550 id's in the IN-clause resulting into 800+ seconds; (b) 550 queries with a single id in the IN-clause resulting into overall time of <60 seconds; The table consists of 950.0

Re: [GENERAL] Optimize query: time of "single * IN(many)" > time of "many * IN(single)"

2004-01-08 Thread Tom Lane
"Paul Janssen" <[EMAIL PROTECTED]> writes: > Can anyone help me out with the following situation: >(a) a single query with 550 id's in the IN-clause resulting into 800+ > seconds; >(b) 550 queries with a single id in the IN-clause resulting into overall > time of <60 seconds; > The table

Re: [GENERAL] Optimize query: time of "single * IN(many)" > time

2004-01-08 Thread Alvaro Herrera
On Thu, Jan 08, 2004 at 06:28:14AM -0500, Dave Smith wrote: > Firstly you should always provide an explain from your query before > posting to this list. You mean "while posting", because he can't possible provide the explain before having the means to do so, can he? :-) > I think the problem is