Re: BitMapScan performance degradation

From: db(at)zigo(dot)dhs(dot)org
To: Jérôme BENOIS <benois(at)argia-engineering(dot)fr>
Cc: "PostgreSQL Performance" <pgsql-performance(at)postgresql(dot)org>, "Xavier Milliard" <milliard(at)argia(dot)fr>, "Laurent BELMONTE" <belmonte(at)argia(dot)fr>
Subject: Re: BitMapScan performance degradation
Date: 2006-11-21 15:12:47
Message-ID: 3389.192.121.104.120.1164121967.squirrel@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> When enable_bitmapscan is enabled this query cost 51893.491 ms and when
> is disabled 117.709 ms. But i heard bitmapscan feature improved
> performance, can you help me ?

The standard question we always ask first is if you have run VACUUM
ANALYZE recently?

Are all the costs and estimated number of rows the same after you have run
VACUUM ANALYZE? If not you might want to show that new plan as well.

/Dennis

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jérôme BENOIS 2006-11-21 15:35:56 Re: BitMapScan performance degradation
Previous Message Markus Schaber 2006-11-21 13:22:40 Re: Postgres server crash