Re: [GENERAL] Bitmap Heap Scan takes a lot of time

On 23 avr, 14:12, [EMAIL PROTECTED] (Gregory Stark) wrote: > <[EMAIL PROTECTED]> 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

Re: [GENERAL] Bitmap Heap Scan takes a lot of time

<[EMAIL PROTECTED]> 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 an