Postgres Pro
Downloads
Home   >   mailing lists

SELECT * FROM t where p or q; - Mailing list pgsql-sql

From frbn@efbs-seafrigo.fr
Subject SELECT * FROM t where p or q;
Date
Msg-id 3BF51764.8BEAC873@efbs-seafrigo.fr
Whole thread Raw
Responses Re: SELECT * FROM t where p or q;  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: SELECT * FROM t where p or q;  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
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.

pgsql-sql by date:

Previous
From: "Jack Gao"
Date:
Subject: Re: Is this a bug?
Next
From: Janning Vygen
Date:
Subject: image db with keywords? n:n or 1:n relation