Re: indexing for left join

From: Richard Huxton <dev(at)archonet(dot)com>
To: mailreg(at)numerixtechnology(dot)de
Cc: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: indexing for left join
Date: 2006-01-19 15:52:45
Message-ID: 43CFB5CD.9070704@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

T E Schmitz wrote:
>
> Sequential despite the indices? Or is this because the tables of my test
> DB are virtually empty?

Yes - read up on analyse and column statistics for details. Oh, you've
probably missed about vacuuming too.

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Rod Taylor 2006-01-19 15:57:09 Re: indexing for left join
Previous Message T E Schmitz 2006-01-19 15:41:25 indexing for left join