| From: | Tomasz Myrta <jasiek(at)klaster(dot)net> |
|---|---|
| To: | pginfo <pginfo(at)t1(dot)unisoftbg(dot)com> |
| Cc: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Interest query plan |
| Date: | 2003-10-07 17:11:36 |
| Message-ID: | 3F82F3C8.6090102@klaster.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
> I have also another good example for a slow left join work.
> Can I do it better?
> explain analyze select * from a_doc D join A_SKLAD S ON(D.IDS=S.IDS_DOC) join
> A_MED M ON(S.IDS_MED=M.IDS) where d
> .date_op >= 9600 and d.date_op <= 9700;
> -> Seq Scan on a_doc d (cost=0.00..13145.43 rows=11167
> width=1344) (actual time=0.22..1316.10 rows=9432 loops=1)
I wouldn't expect too much from query, which starts joining over 10k
rows and returns over 60000 rows. Do you really need such a big result?
Regards,
Tomasz Myrta
| From | Date | Subject | |
|---|---|---|---|
| Next Message | George Weaver | 2003-10-07 17:16:50 | Re: Problem with Escape charactor |
| Previous Message | Tomasz Myrta | 2003-10-07 16:17:56 | Re: Interest query plan |