Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 0494C2E015A
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 13 Feb 2008 13:47:09 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 09009-09 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 13 Feb 2008 13:47:06 -0400 (AST)
Received: from mail.ptt.uni-duisburg.de (trottoir.ptt.uni-duisburg.de
	[134.91.151.36])
	by postgresql.org (Postfix) with ESMTP id CC36A2E014B
	for <pgsql-performance@postgresql.org>;
	Wed, 13 Feb 2008 13:47:05 -0400 (AST)
Received: (qmail 59351 invoked by uid 0); 13 Feb 2008 17:47:25 -0000
Received: from 134.91.151.30 by trottoir.ptt.uni-duisburg.de (envelope-from
	<zaksek@ptt.uni-due.de>, uid 89) with qmail-scanner-1.25
	(sweep: 2.44.1/4.16.0. /636764. spamassassin: 3.2.1.  
	Clear:RC:1(134.91.151.30):.
	Processed in 3.83255 secs); 13 Feb 2008 17:47:25 -0000
X-Qmail-Scanner-Mail-From: zaksek@ptt.uni-due.de via
	trottoir.ptt.uni-duisburg.de
X-Qmail-Scanner: 1.25 (Clear:RC:1(134.91.151.30):. Processed in 3.83255 secs)
Received: from unknown (HELO finkenstrasse.ptt.uni-duisburg.de)
	(zaksek@ptt.uni-due.de@134.91.151.30)
	by mail.ptt.uni-duisburg.de with ESMTPA; 13 Feb 2008 17:47:21 -0000
Message-ID: <47B32D0B.7030503@ptt.uni-due.de>
Date: Wed, 13 Feb 2008 18:46:51 +0100
From: Thomas Zaksek <zaksek@ptt.uni-due.de>
User-Agent: Thunderbird 2.0.0.9 (X11/20071115)
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: Join Query Perfomance Issue
References: <47B08F19.8000500@ptt.uni-due.de>
	<4544e0330802121234l33be13a9g5dec39ef032f6268@mail.gmail.com>
	<47B2D840.6060802@ptt.uni-due.de> <15212.1202917722@sss.pgh.pa.us>
In-Reply-To: <15212.1202917722@sss.pgh.pa.us>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001
X-Spam-Level: 
X-Archive-Number: 200802/143
X-Sequence-Number: 28685

> For so many rows I'm surprised it's not using a bitmap indexscan.
> What PG version is this?  How big are these tables?
>
> 			regards, tom lane

Its PG 8.2.6 on Freebsd.

messungen_v_dat_2007_11_12 ist about 4 million rows and messwerte is 
about 10 million rows.