Postgres Pro
Downloads
Home   >   mailing lists

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

From Stephan Szabo
Subject Re: SELECT * FROM t where p or q;
Date
Msg-id 20011120000953.M53451-100000@megazone23.bigpanda.com
Whole thread Raw
In response to SELECT * FROM t where p or q;  (frbn@efbs-seafrigo.fr)
List pgsql-sql
Tree view 
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?

pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Foreign Key Constraint Deletion Order
Next
From: Dino Cherian
Date:
Subject: When to connect and disconnect Connection