Postgres Pro
Downloads
Home   >   mailing lists

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

From Gavin Flower
Subject Re: Our trial to TPC-DS but optimizer made unreasonable plan
Date
Msg-id 55DE7FAF.9060802@archidevsys.co.nz
Whole thread Raw
In response to Re: Our trial to TPC-DS but optimizer made unreasonable plan  (Kouhei Kaigai <kaigai@ak.jp.nec.com>)
Responses Re: Our trial to TPC-DS but optimizer made unreasonable plan  (Kouhei Kaigai <kaigai@ak.jp.nec.com>)
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)?

[...]


-Gavin

pgsql-hackers by date:

Previous
From: Kouhei Kaigai
Date:
Subject: Re: Foreign join pushdown vs EvalPlanQual
Next
From: Kouhei Kaigai
Date:
Subject: Re: Our trial to TPC-DS but optimizer made unreasonable plan