Postgres Pro
Downloads
Home   >   mailing lists

Re: Our trial to TPC-DS but optimizer made unreasonable plan - Mailing list pgsql-hackers

From Kouhei Kaigai
Subject Re: Our trial to TPC-DS but optimizer made unreasonable plan
Date
Msg-id 9A28C8860F777E439AA12E8AEA7694F801138C98@BPXM15GP.gisp.nec.co.jp
Whole thread Raw
In response to Re: Our trial to TPC-DS but optimizer made unreasonable plan  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
List pgsql-hackers
Tree view 
> 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)?
>
Text is also welcome, of course.
--
NEC Business Creation Division / PG-Strom Project
KaiGai Kohei <kaigai@ak.jp.nec.com>

pgsql-hackers by date:

Previous
From: Gavin Flower
Date:
Subject: Re: Our trial to TPC-DS but optimizer made unreasonable plan
Next
From: Etsuro Fujita
Date:
Subject: Re: Foreign join pushdown vs EvalPlanQual