PostgreSQL explain plan operations
to be continued > — what does «Bitmap Heap Scan» phase do? A plain indexscan fetches one tuple-pointer at a time from the index, and immediately visits that tuple in the table. A bitmap scan fetches all the tuple-pointers from the index in one go, sorts them using an in-memory «bitmap» data structure, and then … Читать далее