| From: | Roberto Moreda <moreda(at)sanluis(dot)net> |
|---|---|
| To: | gpsql-general <pgsql-general(at)hub(dot)org> |
| Subject: | Slow joins |
| Date: | 1999-08-05 14:58:58 |
| Message-ID: | 19990805165858.C3071@sanluis.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I have a speed problem with a query that involves 3 tables.
I focused the problem in a scan in a big table (70000 rows) using a indexed
field. The field is a "flag" field which values only can be 'Y' or 'N'.
In the query I look for the values 'N' (average value = 10 rows over the
70000). Postgres does a Seq Scan.
How can I speed up that scan? How can I force the use of the index?
Where can I found general recomendations to speed up queries?
TIA
Roberto
--
Roberto Moreda
Resp. Dpto. Informática Handem/San Luis
Tlf +34 981 779000
Fax +34 981 779022
Pol. Piadela Sur, Autovía A6 Sal.567
15300 Betanzos (A Coruña) - España
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roberto Moreda | 1999-08-05 16:32:14 | eqsel ? |
| Previous Message | Héctor Morales | 1999-08-05 14:41:30 | Re: [GENERAL] Problem with pgaccess |