Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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;

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

  Bruce Momjian                        |
  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


pgsql-general by date

Next:From: LeonDate: 1999-06-29 16:37:36
Subject: Re: [GENERAL] Fast join
Previous:From: Herouth MaozDate: 1999-06-29 15:53:05
Subject: Re: [GENERAL] Fast join

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group