<[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 and include information to compare against the estimates. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
