You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository has been archived by the owner on Jun 18, 2024. It is now read-only.
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
check_default_partition_contents()
CopyTo()
validateCheckConstraint()
validateForeignKeyConstraint()
Index Scans to leverage column projections
table_index_fetch_tuple_check()
unique_key_recheck()
check_exclusion_or_unique_constraint()
IndexNextWithReorder()
get_actual_variable_range()
&&
@ashwinstar modified following functions to leverage column projections.
check_default_partition_contents()
CopyTo()
validateCheckConstraint()
Rest mentioned above are still remaining.
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.
The text was updated successfully, but these errors were encountered: