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
"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
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