Re: Our trial to TPC-DS but optimizer made unreasonable plan

From: Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Our trial to TPC-DS but optimizer made unreasonable plan
Date: 2015-08-27 03:10:39
Message-ID: 55DE7FAF.9060802@archidevsys.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 27/08/15 13:36, Kouhei Kaigai wrote:
[...]
> My measurement is done on v9.5 based system. So, it also seems to me
> replacement of CHAR(n) by VARCHAR(n) will make sense.

Is there any reason to not simply use text instead of CHAR(n) or VARCHAR(n)?

[...]

-Gavin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kouhei Kaigai 2015-08-27 06:15:37 Re: Our trial to TPC-DS but optimizer made unreasonable plan
Previous Message Kouhei Kaigai 2015-08-27 02:08:43 Re: Foreign join pushdown vs EvalPlanQual