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