Re: Gained %20 performance after disabling bitmapscan

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: yavuzselim(dot)sertoglu(at)medyasoft(dot)com(dot)tr
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Gained %20 performance after disabling bitmapscan
Date: 2018-10-26 17:54:32
Message-ID: CAMkU=1wyTzvG7smk=xK7mnrZf4-WBakPoBNny1X4oceXUq1c1w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Oct 22, 2018 at 3:20 AM Yavuz Selim Sertoglu <
yavuzselim(dot)sertoglu(at)medyasoft(dot)com(dot)tr> wrote:

> Thanks for the reply Jeff,
>
> I know 20ms is nothing but it shows me that there is a problem with my
> configuration. I want to find it.
>

This is a dangerous assumption. This is no configuration you can come up
with which will cause the planner to be within 20% of perfection in all
cases. Given the other plans you've shown and discussed, I think this is
just chasing our own tail.

Cheers,

Jeff

>

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Justin Pryzby 2018-10-28 21:49:24 Re: DELETE / UPDATE from partition not optimized (11.0)
Previous Message Justin Pryzby 2018-10-26 15:45:40 Re: DELETE / UPDATE from partition not optimized (11.0)