Re: usage of indexes for inner joins

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: bayesianlogic(at)acm(dot)org
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: usage of indexes for inner joins
Date: 2007-09-28 05:10:22
Message-ID: 21421.1190956222@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Jan Theodore Galkowski" <bayesianlogic(at)acm(dot)org> writes:
> Total runtime: .169 ms ;

> Like *how* *come*?

You have a problem with 0.1 ms runtime?

But to correct your obvious misunderstanding: yes, the plan depends on
the table size, as well it should.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stefan Schwarzer 2007-09-28 07:47:16 Normalized Tables & SELECT [was: Find "smallest common year"]
Previous Message Jan Theodore Galkowski 2007-09-28 04:41:48 usage of indexes for inner joins