<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><span class="Apple-style-span" style="font-size: 12px; "><div>I've several systems with 8-24 GB of RAM running postgres and postgis. I built postgres as a 64-bit executable to take advantage of the larger address space. As a rule for databases, they are memory hungry. I generally follow: effective cache size, 50% RAM; shared_buffers, 25% RAM. There are other PG tuning parameters available in performance docs/discussions on the web.</div><div><br></div><div>With only 2GB of RAM, the bit-width of postgres shouldn't matter, and your setting of 1.5 GB shmmax seems a little too large. Try keeping it below 1.25 GB, or even 1 GB. Since you said this is only a prototype, performance shouldn't be a top priority. You also don't want to starve the OS of resources. Consider starting with your postgres setting half or even a quarter of what I stated above. Also, consider lowering the max_connections setting; each connection requires more shared memory. This way you can also limit the size of your kernel resources.</div><div><br></div><div>You can also dynamically change the kernel parameters with `sysctl -w PARAMETER=VALUE` from the command line to find a setting you're comfortable with before committing it to /etc/sysctl.conf. The only reason to have large memory space for postgres is to store as much of the database as possible in memory, i.e., faster access and less/no swapping.</div><div><br class="khtml-block-placeholder"></div><div>As for the pgAdmin question, it's a good tool, but it ultimately comes down to what you're comfortable with. I prefer the command line.</div><div><br></div><div>Hope that clears things up at least a bit.</div><div>-B-</div><div><br></div><div><br></div><div><font class="Apple-style-span" face="Courier New"><span class="Apple-style-span" style="font-family: 'Courier New'; "><span class="Apple-style-span" style="font-family: 'Courier New'; ">--- Let us all bask in television's warm glowing warming glow ---</span></span></font></div><div><font class="Apple-style-span" face="Courier New"><span class="Apple-style-span" style="font-family: 'Courier New'; "><span class="Apple-style-span" style="font-family: 'Courier New'; ">Scott Brunza </span></span><span class="Apple-style-span" style="font-family: 'Courier New'; "><span class="Apple-style-span" style="font-family: 'Courier New'; ">860.326.3637 </span></span><span class="Apple-style-span" style="font-family: 'Courier New'; "><span class="Apple-style-span" style="font-family: 'Courier New'; "><a href="mailto:scottso@sonalysts.com">scottso@sonalysts.com</a></span></span></font></div></span></div><div><br></div></div></span><font class="Apple-style-span" face="'Courier New'" size="3"><span class="Apple-style-span" style="font-size: 12px; ">This<span class="Apple-converted-space"> </span>e-mail and any files transmitted with it may be proprietary</span></font></span><div><span class="Apple-style-span" style="border-collapse: separate; font-variant: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-style: normal; font-weight: normal; color: rgb(0, 0, 0); "><font class="Apple-style-span" face="'Courier New'" size="3"><span class="Apple-style-span" style="font-size: 12px; ">and are intended solely for the use of the individual or entity</span></font></span></div><div><span class="Apple-style-span" style="border-collapse: separate; font-variant: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-style: normal; font-weight: normal; color: rgb(0, 0, 0); "><font class="Apple-style-span" face="'Courier New'" size="3"><span class="Apple-style-span" style="font-size: 12px; ">to whom they are addressed. If you have received this e-mail in</span></font></span></div><div><span class="Apple-style-span" style="border-collapse: separate; font-variant: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-style: normal; font-weight: normal; color: rgb(0, 0, 0); "><font class="Apple-style-span" face="'Courier New'" size="3"><span class="Apple-style-span" style="font-size: 12px; ">error please notify the sender.</span></font></span></div></span>
</div>
<br></body></html>