Received: from megazone.bigpanda.com ([63.150.15.178]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAK8AGm68700 for ; Tue, 20 Nov 2001 03:10:16 -0500 (EST) (envelope-from sszabo@megazone23.bigpanda.com) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id D4EA2D5E6; Tue, 20 Nov 2001 00:10:16 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id CA9BF5BE7; Tue, 20 Nov 2001 00:10:16 -0800 (PST) Date: Tue, 20 Nov 2001 00:10:16 -0800 (PST) From: Stephan Szabo To: Cc: Subject: Re: SELECT * FROM t where p or q; In-Reply-To: <3BF51764.8BEAC873@efbs-seafrigo.fr> Message-ID: <20011120000953.M53451-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200111/288 X-Sequence-Number: 5670 On Fri, 16 Nov 2001 frbn@efbs-seafrigo.fr wrote: > hi, > on a +10 millions rec table, a simple select: > > SELECT * FROM tab where num = x; > > time: 5 secondes > > SELECT * FROM tab where num = y; > > time: 5 secondes > > > SELECT * FROM tab WHERE num = x OR num = y; > > time: more than 10 mn !!! > > num is an integer. Have you run vacuum analyze, what does explain show on the three queries?