Postgres Pro
Downloads
Home   >   mailing lists

Re: Join Query Perfomance Issue - Mailing list pgsql-performance

From Thomas Zaksek
Subject Re: Join Query Perfomance Issue
Date
Msg-id 47B32D0B.7030503@ptt.uni-due.de
Whole thread Raw
In response to Re: Join Query Perfomance Issue  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
> 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.

pgsql-performance by date:

Previous
From: Kenneth Marshall
Date:
Subject: Re: Anyone using a SAN?
Next
From: Josh Berkus
Date:
Subject: HOT TOAST?