shared_buffers Question
| От | Joe Lester |
|---|---|
| Тема | shared_buffers Question |
| Дата | |
| Msg-id | 4C640A63-E30E-11D8-B34E-000A95A58EA0@sweetwater.com обсуждение исходный текст |
| Ответы |
Re: shared_buffers Question
|
| Список | pgsql-general |
I've been running a postgres server on a Mac (10.3, 512MB RAM) with 200 clients connecting for about 2 months without a crash. However just yesterday the database and all the clients hung. When I looked at the Mac I'm using as the postgres server it had a window up that said that there was no more disk space available to write memory too. I ended up having to restart the whole machine. I would like to configure postgres so that is does not rely so heavily on disk-based memory but, rather, tries to stay within the scope of the 512MB of physical memory in the Mac. Am I correct in thinking that lowering that value of shared_buffers in postgresql.conf will reduce the amount of disk space that is swapped for memory? I lowered the value from 2000 down to 500. Was that the right thing to do or should I have gone the other way? Any other settings I should look at? Thanks!
В списке pgsql-general по дате отправления: