3 ms·
> Off the top of my head, Postgres can scan in the following ways: sequential scan, parallel sequential scan, index scan, parallel index scan, index-only scan,
by Izkata 2y ago
> Off the top of my head, Postgres can scan in the following ways: sequential scan, parallel sequential scan, index scan, parallel index scan, index-only scan, and bitmap scan.
I don't think that last one is a thing. There is both "bitmap heap scan" and "bitmap index scan" though.
- sgarland 2y agoIt’s the generalized parent of both of those (since you will not see one without the other). You’re technically correct, but I’m also not the only one [0] who uses this term. [0]: https://www.cybertec-postgresql.com/en/postgresql-indexing-index-scan-vs-bitmap-scan-vs-sequential-scan-basics/ https://www.cybertec-postgresql.com/en/postgresql-indexing-i...