how much mem to give postgres?
От | Josh Close |
---|---|
Тема | how much mem to give postgres? |
Дата | |
Msg-id | 4a0cafe2041019153133f854e9@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: how much mem to give postgres?
Re: how much mem to give postgres? |
Список | pgsql-performance |
I'm trying to figure out what I need to do to get my postgres server moving faster. It's just crawling right now. It's on a p4 HT with 2 gigs of mem. I was thinking I need to increase the amount of shared buffers, but I've been told "the sweet spot for shared_buffers is usually on the order of 10000 buffers". I already have it set at 21,078. If you have, say 100 gigs of ram, are you supposed to still only give postgres 10,000? Also, do I need to up the shmmax at all? I've used the formula "250 kB + 8.2 kB * shared_buffers + 14.2 kB * max_connections up to infinity" at http://www.postgresql.org/docs/7.4/interactive/kernel-resources.html#SYSVIPC but it's never quite high enough, so I just make sure it's above the amount that the postgres log says it needs. What else can I do to speed this server up? I'm running vacuum analyze on the heavily updated/inserted/deleted db's once an hour, and doing a full vacuum once a night. Should I change the vacuum mem setting at all? Are there any other settings I should be concerned with? I've heard about the effective_cache_size setting, but I haven't seen anything on what the size should be. Any help would be great. This server is very very slow at the moment. Also, I'm using a 2.6.8.1 kernel with high mem enabled, so all the ram is recognized. Thanks. -Josh
В списке pgsql-performance по дате отправления: