Postgres Pro
Downloads
Home   >   mailing lists

Re: Bitmap Heap Scan takes a lot of time - Mailing list pgsql-general

From Gregory Stark
Subject Re: Bitmap Heap Scan takes a lot of time
Date
Msg-id 877ieou5wt.fsf@oxford.xeocode.com
Whole thread Raw
In response to Bitmap Heap Scan takes a lot of time  (mateo21@siteduzero.com)
List pgsql-general
Tree view 
<mateo21@siteduzero.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
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's PostGIS support!

pgsql-general by date:

Previous
From: Tomasz Ostrowski
Date:
Subject: Re: Need to update all my 60 million rows at once without transactional integrity
Next
From: Ivan Sergio Borgonovo
Date:
Subject: Re: Debian etch, backport postgresql 8.3 experiences?