| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Varun Kacholia <varunk(at)cse(dot)iitb(dot)ac(dot)in> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: weird EXPLAIN |
| Date: | 2002-06-17 22:47:58 |
| Message-ID: | 20020617154554.M53873-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 18 Jun 2002, Varun Kacholia wrote:
> hi ,
> I have just migrated to PostgreSQL...and found the following wierd :
>
> suryadb=# explain select * from dbwin where id in (select id from wdwin
> where word='bacd');
> NOTICE: QUERY PLAN:
> Seq Scan on dbwin (cost=0.00..8158.20 rows=1000 width=76)
> ^^^^^^^^^^^^^^^^^^
> SubPlan
> -> Materialize (cost=8.14..8.14 rows=10 width=4)
> -> Index Scan using wdkwin on wdwin (cost=0.00..8.14 rows=10 width=4)
Although I'm not sure it'd help this case , it also looks like you
haven't used VACUUM ANALYZE on the tables since the above looks an awful
lot like the defaults.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Parker Thompson | 2002-06-17 23:04:57 | regular expression question |
| Previous Message | Jeff MacDonald | 2002-06-17 22:19:39 | Re: website design |