greenplum-db / postgres-archive

96 stars 28 forks source link

Pass down projection information #16

Open Eulerizeit opened 4 years ago

Eulerizeit commented 4 years ago

This is a subset of issue #13

We closed the scan cols patch in Postgres this is an issue that when finished will replace that patch with, most likely, several patches.

Included in the patch set will be:

Effectively this should be decoupling the ingrained assumptions that a 'row' is the atomic thing being grabbed.

Eulerizeit commented 4 years ago

From a previous investigation on improvements for scan:

Column store layout can be leveraged to scan only subset of columns from table which are requied to perform the task. Following functions don't need to pull full tuple but can be optimized to only get required subset of columns.

Sequential Scan to leverage column projections

Index Scans to leverage column projections

&&

@ashwinstar modified following functions to leverage column projections.

soumyadeep2007 commented 4 years ago

ExecInitBitmapHeapScan() should also pass down the projection list if possible.

soumyadeep2007 commented 3 years ago

w/ @jchampio validateCheckConstraint() was removed in upstream commit: f1fcf2d3b2e0. So we don't need to worry about it anymore.