Re: Question with hashed IN

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Question with hashed IN
Date: 2003-08-17 04:43:03
Message-ID: 8848.1061095383@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> writes:
>> with reltuples=1000 for pktest, query takes about 96 seconds
>> reltuples=10000, query takes about 15 seconds
>> reltuples=100000, query takes about 8 seconds

> Errm, I meant in the cases where it still chose a hashed
> subplan. Stupid cold medicine.

I'm confused too. Please explain again when you're feeling better...

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-08-17 04:43:50 Re: WITH HOLD and pooled connections
Previous Message Tom Lane 2003-08-17 04:42:06 Re: "truncate all"?