<mateo21@xxxxxxxxxxxxxx> 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!
