<para>

Specifies the amount of memory to be used by internal sort operations

and hash tables before writing to temporary disk files. The value

defaults toone megabyte (<literal>1MB</>).

defaults tofour megabytes (<literal>4MB</>).

Note that for a complex query, several sort or hash operations might be

running in parallel; each operation will be allowed to use as much memory

as this value specifies before it starts to write data into temporary

Specifies the maximum amount of memory to be used by maintenance

operations, such as <command>VACUUM</command>, <command>CREATE

INDEX</>, and <command>ALTER TABLE ADD FOREIGN KEY</>. It defaults

to16 megabytes (<literal>16MB</>). Since only one of these

to64 megabytes (<literal>64MB</>). Since only one of these

operations can be executed at a time by a database session, and

an installation normally doesn't have many of them running

concurrently, it's safe to set this value significantly larger

},

&work_mem,

1024,64,MAX_KILOBYTES,

4096,64,MAX_KILOBYTES,

NULL,NULL,NULL

},

},

&maintenance_work_mem,

16384,1024,MAX_KILOBYTES,

65536,1024,MAX_KILOBYTES,

NULL,NULL,NULL

},

# per transaction slot, plus lock space (see max_locks_per_transaction).

# It is not advisable to set max_prepared_transactions nonzero unless you

# actively intend to use prepared transactions.

#work_mem =1MB# min 64kB

#maintenance_work_mem =16MB# min 1MB

#work_mem =4MB# min 64kB

#maintenance_work_mem =64MB# min 1MB

#autovacuum_work_mem = -1# min 1MB, or -1 to use maintenance_work_mem

#max_stack_depth = 2MB# min 100kB

#dynamic_shared_memory_type = posix # the default is the first option