Postgres Pro
Downloads
Home   >   mailing lists

Re: Optimizing Bitmap Heap Scan. - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Optimizing Bitmap Heap Scan.
Date
Msg-id 4B1E2EE2020000250002D207@gw.wicourts.gov
Whole thread Raw
In response to Re: Optimizing Bitmap Heap Scan.  (Lennin Caro <lennin.caro@yahoo.com>)
List pgsql-performance
Tree view 
Lennin Caro <lennin.caro@yahoo.com> wrote:

> I have run vacuum full

That's not usually a good idea.  For one thing, it will tend to
bloat your indexes.

-Kevin

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Vacuum running out of memory
Next
From: Robert Haas
Date:
Subject: Re: performance penalty between Postgresql 8.3.8 and 8.4.1