Specifies a cache size that is used by dbmlsync when building the upload.
mem=number[ K | M ]; ...
Specifies the size of the cache used for building the upload, in units of bytes. A larger cache means that dbmlsync can keep more pages of data in memory, thus reducing the number of disk reads/writes and improving performance.
Use the suffix k or m to specify units of kilobytes or megabytes, respectively. The default is 1M.
This option has a short form and long form: you can use mem or Memory.
You can also store extended options in the database. For more information about dbmlsync extended options, see Introduction to dbmlsync extended options.
The following dbmlsync command line illustrates how you can set this option when you start dbmlsync:
dbmlsync -e "mem=2M"
The following SQL statement illustrates how you can store this option in the database:
CREATE SYNCHRONIZATION SUBSCRIPTION TO sales_publication FOR ml_user1 OPTION mem='2m';