Postgres Pro
Downloads
Home   >   mailing lists

Re: usage of indexes for inner joins - Mailing list pgsql-general

From Tom Lane
Subject Re: usage of indexes for inner joins
Date
Msg-id 21421.1190956222@sss.pgh.pa.us
Whole thread Raw
In response to usage of indexes for inner joins  ("Jan Theodore Galkowski" <bayesianlogic@acm.org>)
List pgsql-general
Tree view 
"Jan Theodore Galkowski" <bayesianlogic@acm.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

pgsql-general by date:

Previous
From: "Jan Theodore Galkowski"
Date:
Subject: usage of indexes for inner joins
Next
From: Stefan Schwarzer
Date:
Subject: Normalized Tables & SELECT [was: Find "smallest common year"]