Postgres Pro
Downloads
Home   >   mailing lists

Re: indexing for left join - Mailing list pgsql-sql

From Richard Huxton
Subject Re: indexing for left join
Date
Msg-id 43CFB5CD.9070704@archonet.com
Whole thread Raw
In response to indexing for left join  (T E Schmitz <mailreg@numerixtechnology.de>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Rod Taylor
Date:
Subject: Re: indexing for left join
Next
From: "Leif B. Kristensen"
Date:
Subject: Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist"