Re: Gained %20 performance after disabling bitmapscan

From: Vladimir Ryabtsev <greatvovan(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-19 18:09:03
Message-ID: CAMqTPqm8ueo94ovPQuCeRkG5nK9mzLvnRgrQWBCrCVfcvuWbaQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Yavuz, cannot add much to other points but as for index-only scan, an
(auto)vacuum must be run in order to optimizer understand it can utilize
index-only scan. Please check if autovacuum was run on the table after
index creation and if no, run it manually.

Vlad

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Janes 2018-10-19 19:40:57 Re: Gained %20 performance after disabling bitmapscan
Previous Message Tom Lane 2018-10-19 13:52:04 Re: Gained %20 performance after disabling bitmapscan