| From: | "Grembowicz, Kenneth" <GrembowiczK(at)NAVO(dot)NAVY(dot)MIL> |
|---|---|
| To: | "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Subqueries using IN |
| Date: | 2000-04-11 18:07:08 |
| Message-ID: | 78166D547FD9D2119FA700805F9FA971041A9FF8@navont3.navo.navy.mil |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
I have a database with approximately 2 millions rows. I have constructed a
select statement with one subquery and it is EXTREMELY slow. If the
conditions return on record, it takes almost 5 minutes. Practical usage
returns a couple thousand records, but as you would guess I can't wait
days....ANY SUGGESTIONS??????????????
Kenny G.
______________________________________________________
Kenneth P. Grembowicz
Oceanographic Databases Division, Code N51
Naval Oceanographic Office
1002 Balch Blvd.
Stennis Space Center, MS 39522-5001
Tel: (228) 688-5675
Fax: (228) 688-5778
e-mail: grembowiczk(at)navo(dot)navy(dot)mil
| From | Date | Subject | |
|---|---|---|---|
| Next Message | kaiq | 2000-04-11 19:28:16 | Re: Subqueries using IN |
| Previous Message | Margarita Barvinok | 2000-04-11 15:59:23 | ORDER clause |