Re: [GENERAL] Fast join

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: Leon <leon(at)udmnet(dot)ru>
Cc: "'pgsql-general(at)hub(dot)org'" <pgsql-general(at)hub(dot)org>
Subject: Re: [GENERAL] Fast join
Date: 1999-06-29 16:01:57
Message-ID: 199906291601.MAA04834@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Oh, I'm sorry, it was a typo. But believe me, such behaviour is
> persistent notwithstanding any type of qualification. It is, so
> to say, tested and approved. Look at the explanations of Postgres
> of his plan of query on database whose creation I showed you
> earlier (it has two tables of 10000 rows, properly vacuumed):
>
> -=--------------------------------

> adb=> EXPLAIN SELECT COUNT(*) FROM atable WHERE atable.cfield = btable.cfield
> AND atable.afield<10;
> NOTICE: QUERY PLAN:

But your only restriction is < 10. That is not enough. Make it = 10,
and I think it will use the index.

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Leon 1999-06-29 16:37:36 Re: [GENERAL] Fast join
Previous Message Herouth Maoz 1999-06-29 15:53:05 Re: [GENERAL] Fast join