Hi Dennis, Le mardi 21 novembre 2006 à 16:12 +0100, db@xxxxxxxxxxxx a écrit : > > 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? Yes i ran VACCUUM ANALYZE just before my EXPLAIN. > 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 Jérôme.
Attachment:
signature.asc
Description: Ceci est une partie de message =?ISO-8859-1?Q?num=E9riquement?= =?ISO-8859-1?Q?_sign=E9e?=
