Re: anti-join chosen even when slower than old plan

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Robert Haas" <robertmhaas(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>, "Mladen Gogala" <mladen(dot)gogala(at)vmsinfo(dot)com>
Subject: Re: anti-join chosen even when slower than old plan
Date: 2010-11-11 19:50:28
Message-ID: 4CDBF4A402000025000375E8@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Erm ... you can in fact do "ALTER USER SET random_page_cost"
> today.

Ouch. I'm embarrassed to have missed that. I'll do that instead of
adding those settings to the scripts, then.

Thanks for pointing that out.

-Kevin

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jon Nelson 2010-11-11 19:52:12 Re: anti-join chosen even when slower than old plan
Previous Message Kevin Grittner 2010-11-11 19:47:53 Re: anti-join chosen even when slower than old plan