Size for vacuum_mem
От | Francisco Reyes |
---|---|
Тема | Size for vacuum_mem |
Дата | |
Msg-id | 20021204191246.F4306-100000@zoraida.natserv.net обсуждение исходный текст |
Ответы |
Re: Size for vacuum_mem
|
Список | pgsql-general |
Trying to improve my vacuum times. Currently have vacuum_mem set to 128MB. What is my best bet to improve vacuum time? Increasing this number? Have 1GB of ram in the machine. Some of my settings: wal_buffers = 256 # min 4 shared_buffers = 12288 #96 MB (buffers * 8K) sort_mem = 131072 # 128 MB measured in K vacuum_mem = 131072 # 128 MB measured in K wal_files = 10 # range 0-64 checkpoint_segments = 12 # in logfile segments (16MB each), min 1 checkpoint_timeout = 900 # in seconds, range 30-3600 Currently a vacuum full takes 3+ hours and very soon the amount of data will increase. Have a very high turn over of data because this is a copy of data on a different system. Because of that I every day delete/merge entire range of dates deleting/adding million of records.
В списке pgsql-general по дате отправления: