On Thu, Nov 19, 2015 at 8:35 PM, Greg Stark <st...@mit.edu> wrote: > Hm. So a bit of back-of-envelope calculation. If we have want to > buffer at least 1MB for each run -- I think we currently do more > actually -- and say that a 1GB work_mem ought to be enough to run > reasonably (that's per sort after all and there might be multiple > sorts to say nothing of other users on the system). That means we can > merge about 1,000 runs in the final merge. Each run will be about 2GB > currently but 1GB if we quicksort the runs. So the largest table we > can sort in a single pass is 1-2 TB.
For the sake of pedantry I fact checked myself. We calculate the number of tapes based on wanting to buffer 32 blocks plus overhead so about 256kB. So the actual maximum you can handle with 1GB of sort_mem without multiple merges is on the order 4-8TB. -- greg -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
