| From: | Hannu Krosing <hannu(at)tm(dot)ee> |
|---|---|
| To: | Yonatan Goraly <ygoraly(at)sbcglobal(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: [PERFORM] Slow performance with no apparent reason |
| Date: | 2003-10-26 14:38:16 |
| Message-ID: | 1067179095.2604.3.camel@fuji.krosing.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
Yonatan Goraly kirjutas P, 26.10.2003 kell 00:25:
> I am in the process of adding PostgreSQL support for an application,
> in addition to Oracle and MS SQL.
> I am using PostgreSQL version 7.3.2, Red Hat 9.0 on Intel Pentium III
> board.
>
> I have a query that generally looks like this:
>
> SELECT t1.col1, t2.col1 FROM t1, t2 WHERE t1.x=t2.y AND t2.p='string'
> AND t2.q=1
>
> This query is strikingly slow (about 100 sec when both t1 and t2 has
> about 1,200 records, compare with less than 4 sec with MS SQL and
> Oracle)
always send results of EXPLAIN ANALYZE if you ask for help on [PERFORM]
knowing which indexes you have would also help.
and you should have run ANALYZE too.
-----------------
Hannu
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Michel POURE | 2003-10-26 14:46:39 | Re: Problems using PGAdmin III |
| Previous Message | Együd Csaba | 2003-10-26 13:30:26 | Problems using PGAdmin III |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dror Matalon | 2003-10-26 19:44:50 | Various performance questions |
| Previous Message | Yonatan Goraly | 2003-10-26 13:28:21 | Re: Slow performance with no apparent reason |