Skip site navigation (1) Skip section navigation (2)

Re: Bitmap Heap Scan takes a lot of time

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: <mateo21(at)siteduzero(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Bitmap Heap Scan takes a lot of time
Date: 2008-04-23 12:12:02
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
<mateo21(at)siteduzero(dot)com> writes:

> This is the result of an EXPLAIN:
> I suppose that the problem comes from the Bitmap Heap Scan which costs
> a lot, but I can't be totally sure.
> Any idea on where I should be investigating ?

Try posting an EXPLAIN ANALYZE which will actually run the query and include
information to compare against the estimates.

  Gregory Stark
  Ask me about EnterpriseDB's PostGIS support!

In response to


pgsql-general by date

Next:From: Roberts, JonDate: 2008-04-23 12:24:35
Subject: Re: Deny creation of tables for a user
Previous:From: Tomasz OstrowskiDate: 2008-04-23 11:49:30
Subject: Re: Need to update all my 60 million rows at once without transactional integrity

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group