- PostgreSQL Partitioning - Robert Treat
- Babel of PLs - David Fetter
24x7, 365 Enterprise services since 1997
- PostgreSQL Partitioning - Robert Treat
- Babel of PLs - David Fetter
EXPLAIN SELECT * FROM tenk1 WHERE unique1 < 100; QUERY PLAN ------------------------------------------------------------------------------ Bitmap Heap Scan on tenk1 (cost=2.37..232.35 rows=106 width=244) Recheck Cond: (unique1 < 100) -> Bitmap Index Scan on tenk1_unique1 (cost=0.00..2.37 rows=106 width=0) Index Cond: (unique1 < 100)What the above says (per the docs) is :
Here the planner has …