Re: Gained %20 performance after disabling bitmapscan - Mailing list pgsql-performance

From Vladimir Ryabtsev
Subject Re: Gained %20 performance after disabling bitmapscan
Date
Msg-id CAMqTPqm8ueo94ovPQuCeRkG5nK9mzLvnRgrQWBCrCVfcvuWbaQ@mail.gmail.com
Whole thread Raw
In response to Gained %20 performance after disabling bitmapscan  (Yavuz Selim Sertoglu <yavuzselim.sertoglu@medyasoft.com.tr>)
Responses Ynt: Gained %20 performance after disabling bitmapscan  (Yavuz Selim Sertoglu <yavuzselim.sertoglu@medyasoft.com.tr>)
List 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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Gained %20 performance after disabling bitmapscan
Next
From: Jeff Janes
Date:
Subject: Re: Gained %20 performance after disabling bitmapscan