Re: Sql performace - why soo long ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Lada 'Ray' Lostak" <ray(at)unreal64(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Sql performace - why soo long ?
Date: 2004-12-11 17:29:21
Message-ID: 17084.1102786161@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Lada 'Ray' Lostak" <ray(at)unreal64(dot)net> writes:
> I don't understand why following '3' statements are SOO different. We
> run latest PgSQL, OpenBSD 3.4, AMD XP 2000+ and plenty of RAM... CPU was
> fully dedicated to PG.

Define "latest PgSQL". The query plans look like 7.3 or older results
to me. 7.4 should do the IN with a hash join ...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2004-12-11 17:57:25 Re: Checking inequality
Previous Message Stephan Szabo 2004-12-11 16:54:40 Re: Checking inequality