memory tuning
| От | Tom Allison | 
|---|---|
| Тема | memory tuning | 
| Дата | |
| Msg-id | 4498A1D8.4070508@tacocat.net обсуждение исходный текст | 
| Ответы | Re: memory tuning | 
| Список | pgsql-novice | 
I have 2 GB of RAM on this machine and a table with 2.9Million rows. The most I'm getting reported on memory usage for postgres (7.4 can't upgrade just yet) is 2.6%. I have set the following parameters: shared_buffers = 3000 # min 16, at least max_connections*2, 8KB each sort_mem = 262144 # min 64, size in KB vacuum_mem = 262144 # min 1024, size in KB But I'm not utilizing much memory and things are running frighteningly slow. I did run a VACUUM ANALYZE today with no incidents so I wouldn't expect that to be a problem. I don't think there have been more than 10^5 transactions since then (assuming that's not too many?) tips?
В списке pgsql-novice по дате отправления: