Ashwin Agrawal

@khuddlefish please can we drive this PR to completion

Seems can close this PR now in favor of https://github.com/greenplum-db/gpdb/pull/14470 which has all the context and completed performing all the due diligence required to make the informed decision. @QingMa-gp please...

Closing as this enhancement is now tracked under https://github.com/greenplum-db/gpdb/issues/14338

> Another problem we encountered was the poor random access performance of the visibility map. So we added a bitmap to record the tuple id range of all the tuples...

> The index scan has disabled on ao/aocs table for that random access performance on the ao/aocs table is extremely low. But index only scan does not access data files....

Would be also helpful to understand the costing or factors based on which index-only scan will be picked for append-optimized tables (decision used for heap may not be relevant to...

Also, lets make sure to update [README](https://github.com/greenplum-db/gpdb/blob/main/src/backend/access/appendonly/README.md) with all the design for this feature

> Please defer the segno optimization to a completely separate PR and remove from this PR entirely. Seg files don't have to be consulted for index only scans. This is...

> > My point was the system already run out of ports, but the TIME_WAIT connections were still there, not reused. > > If we don't consider TIME_WAIT, the ports...

This https://github.com/greenplum-db/gpdb/pull/14949 explains the scenario and also has test to demonstrate the same