gpdb
gpdb copied to clipboard
Reconcile workfile manager and SharedFileSets in Greenplum 7
Greenplum version or build
Greenplum 7, post PostgreSQL 12 merge
The workfile_mgr_test.c has several merge fixmes and dead code. All of it is related to legacy workfile manager feature. The new SharedFileSet framework from PostgreSQL is merged in Greenplum 7. This serves the same purpose as workfile manager - share temporary files (intermediate work during sorting) among multiple backend processes. This issue to explore whether workfile manager can be replaced entirely with SharedFileSet facility? If yes, let's get it done. Otherwise, figure out a way to reconcile the two facilities without hampering future merges, testability and readability of code.
Do we need add some test for BufFileCreateShared in workfile_mgr_test.c?
@z-wenlin you did some related work, take this a look?
@z-wenlin are we tracking this for 7X? @adam8157
@dpandhi-git Not yet.