Re: Working around, or with, bitmap heap scan?

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: "James A(dot) Robinson" <jim(dot)robinson(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Working around, or with, bitmap heap scan?
Date: 2018-11-02 11:00:05
Message-ID: 44fa6ec751eb8473583edfbf56d51fb7c229bab9.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

James A. Robinson wrote:
> I'm newly exposed to a Postgres 9.4 database system, and am
> trying to understand how I might optimize a query that is taking
> a long time to return.
>
> What I'm observing is an uncached query that takes much much
> longer to complete, sometimes minutes longer, when
> enable_bitmapscan is true. Even after the query result is
> cached, it seems to consistently be 300 ms slower when
> enable_bitmapscan is true (so taking 900 ms to return instead of
> 600 ms).

It would be helpful to have EXPLAIN (ANALYZE, BUFFERS) output for
both queries.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message James A. Robinson 2018-11-02 11:12:51 Re: Working around, or with, bitmap heap scan?
Previous Message GPT 2018-11-02 10:40:41 Re: rw_redis_fdw: SQL Errors when statement is within a function