Tuning 8.3
| От | Roberts, Jon |
|---|---|
| Тема | Tuning 8.3 |
| Дата | |
| Msg-id | 1A6E6D554222284AB25ABE3229A9276271564A@nrtexcus702.int.asurion.com обсуждение исходный текст |
| Ответы |
Re: Tuning 8.3
(Andrew Dunstan <andrew@dunslane.net>)
Re: Tuning 8.3 (Gregory Stark <stark@enterprisedb.com>) pgAgent job throttling ("Roberts, Jon" <Jon.Roberts@asurion.com>) Re: Tuning 8.3 ("Christopher Browne" <cbbrowne@gmail.com>) |
| Список | pgsql-hackers |
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">I need to run about 1000 PostgreSQL connections on a server that I can use about 4 GB of the total 16GB of total RAM. It seems that each session creates a process that uses about 15 MB of RAM just for connecting so I’mrunning out of RAM rather quickly.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">I have these non-default settings:</span></font><p class="MsoNormal"><font face="Arial" size="2"><spanstyle="font-size:10.0pt; font-family:Arial">shared_buffers = 30MB</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">max_connections = 1000 </span></font><p class="MsoNormal"><font face="Arial" size="2"><spanstyle="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">I tried decreasing the work_mem but the db wouldn’t start then.</span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">I’m running version 8.3 on Windows 2003 Server.</span></font><p class="MsoNormal"><font face="Arial" size="2"><spanstyle="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">Any tips for reducing the memory footprint per session? There is pgBouncer but is there anything I cando in the configuration before I go with a connection pooler?</span></font><p class="MsoNormal"><font face="Arial" size="2"><spanstyle="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">Jon</span></font></div>
В списке pgsql-hackers по дате отправления: