We use PostgreSQL for SpatialKey and because of that I have learned a lot about system administration with PostgreSQL. While debugging an issue with tables that had ballooned up I ran into this article which has some great tips for isolating db and table size with a few quick commands. http://www.thegeekstuff.com/2009/05/15-advanced-postgresql-commands-with-examples/

Also check out 15 Practical PostgreSQL database administration commands and backup and restore PostGreSQL with pg dump and psql.

 

<a href="http://www.mcsepractice.com">mcse</a> [url=http://www.mcsepractice.com]mcse[/url]

<a href="http://www.dunkpick.com" target="_blank" title="Nike Air Yeezy">Nike Air Yeezy</a> <a href="http://dunkpick.com/nike-air-yeezy-shoes-c-79.html" target="_blank" title="Air Yeezy Shoes">Air Yeezy Shoes</a> <a href="http://dunkpick.com/air-jordan-shoes-c-91.html" target="_blank" title="Air Jordan Shoes">Air Jordan Shoes</a> <a href="http://dunkpick.com/air-jordan-high-heels-c-82.html" target="_blank" title="Air Jordan High Heels">Air Jordan High Heels</a> <a href="http://dunkpick.com/air-jordan-high-heels-c-82.html" target="_blank" title="Air Jordan High Heels">High Heels</a> <a href="http://dunkpick.com/nike-dunk-sb-c-105.html" target="_blank" title="Nike Dunk SB">Nike Dunk sb</a> <a href="http://dunkpick.com/supra-shoes-c-99.html" target="_blank" title="Supra Shoes">Supra Shoes</a> <a href="http://dunkpick.com/air-force-one-c-107.html" target="_blank" title="Air Force One">Air Force One</a> <a href="http://dunkpick.com/radii-shoes-c-131.html" target="_blank" title="Raddi shoes">Radii shoes</a> <a href="http://dunkpick.com/asics-c-149.html?zenid=8d124e86c8a4044c9ce6241b1fd5e134" target="_blank" title="Asics Shoes">Asics Shoes</a> <a href="http://www.ghdpick.com" target="_blank" title="GHD Hair Straightener">GHD Hair Straightener</a> <a href="http://www.ghdpick.com/ghd-salon-iv-styler-p-4.html" target="_blank" title="GHD IV Salon Styler">GHD IV Salon Styler</a> <a href="http://www.ghdpick.com/ghd-benefit-styler-p-1.html" target="_blank" title="GHD Benefit Styler">GHD Benefit Styler</a> <a href="http://www.ghdpick.com/ghd-iv-styler-dark-p-15.html" target="_blank" title="GHD IV Styler Dark">GHD IV Styler Dark</a> <a href="http://www.ghdpick.com/ghd-mini-iv-styler-p-13.html" target="_blank" title="GHD Mini IV Styler">GHD Mini IV Styler</a> <a href="http://www.ghdpick.com/ghd-mk4-purple-limited-edition-p-9.html" target="_blank" title="GHD MK4 Purple Styler">GHD MK4 Purple Styler</a> <a href="http://www.ghdpick.com/ghd-mk4-styler-gold-p-5.html" target="_blank" title="GHD MK4 Gold Styler">GHD MK4 Gold Styler</a> <a href="http://www.ghdpick.com/pink-ghd-iv-kiss-styler-p-8.html" target="_blank" title="Pink GHD IV Kiss Styler">Pink GHD IV Kiss Styler</a> <a href="http://www.ghdpick.com/ghd-mk5-pure-white-p-10.html" target="_blank" title="Pink GHD MK5 Styler">GHD Mk5 Styler</a>

<a href="http://www.mbtsells.com" target="_blank" title="MBT Shoes">MBT Shoes</a> <a href="http://www.mbtsells.com/mbt-couples-shoes-c-1.html" target="_blank" title="MBT Couples Shoes">MBT Couples Shoes</a> <a href="http://www.mbtsells.com/mbt-men-shoes-c-2.html" target="_blank" title="MBT men Shoes">MBT Men Shoes</a> <a href="http://www.mbtsells.com/mbt-women-shoes-c-7.html" target="_blank" title="MBT Shoes">MBT Women Shoes</a> <a href="http://www.mbtsells.com/mbt-women-shoes-mbt-changa-shoes-c-7_10.html" target="_blank" title="MBT Changa Shoes">MBT Changa Shoes</a> <a href="http://www.mbtsells.com/mbt-men-shoes-mbt-chapa-shoes-c-2_13.html" target="_blank" title="MBT Chapa Shoes">MBT Chapa Shoes</a> <a href="http://www.mbtsells.com/mbt-women-shoes-mbt-lami-shoes-c-7_9.html" target="_blank" title="MBT Lami Shoes">MBT Lami Shoes</a> <a href="http://www.mbtsells.com/mbt-men-shoes-mbt-mwalk-shoes-c-2_3.html" target="_blank" title="MBT M.Walk Shoes">MBT M.Walk Shoes</a> <a href="http://www.mbtsells.com/mbt-sandals-c-18.html" target="_blank" title="MBT Sandals">MBT Sandals</a> <a href="http://www.mbtpick.com" target="_blank" title="MBT Shoes">MBT Shoes</a> <a href="http://www.mbtpick.com/mbt-sandals-c-45.html" target="_blank" title="MBT Sandals">MBT Sandals</a> <a href="http://www.mbtpick.com/mbt-men-shoes-c-29.html" target="_blank" title="MBT Men Shoes">MBT Men Shoes</a> <a href="http://www.mbtpick.com/mbt-women-shoes-c-35.html" target="_blank" title="MBT Women Shoes">MBT Women Shoes</a> <a href="http://www.mbtpick.com/mbt-couples-shoes-c-41.html" target="_blank" title="MBT Couples Shoes">MBT Couples Shoes</a> <a href="http://www.mbtpick.com/mbt-women-shoes-mbt-chapa-shoes-c-35_36.html" target="_blank" title="MBT Chapa Shoes">MBT Chapa Shoes</a> <a href="http://www.mbtpick.com/mbt-women-shoes-mbt-changa-shoes-c-35_39.html" target="_blank" title="MBT Changa Shoes">MBT Changa Shoes</a> <a href="http://www.mbtpick.com/mbt-women-shoes-mbt-lami-shoes-c-35_38.html" target="_blank" title="MBT Lami Shoes">MBT Lami Shoes</a> <a href="http://www.mbtpick.com/mbt-men-shoes-mbt-mwalk-shoes-c-29_34.html" target="_blank" title="MBT M.Walk Shoes">MBT M.Walk Shoes</a>

<a href="http://www.mbtshoesport.com" target="_blank" title="MBT Shoes">MBT Shoes</a> <a href="http://www.mbtshoesport.com/mbt-sandals-c-18.html" target="_blank" title="MBT Sandals">MBT Sandals</a> <a href="http://www.mbtshoesport.com/mbt-men-shoes-c-1.html" target="_blank" title="MBT Men Shoes">MBT Men Shoes</a> <a href="http://www.mbtshoesport.com/mbt-women-shoes-c-2.html" target="_blank" title="MBT Women Shoes">MBT Women Shoes</a> <a href="http://www.mbtshoesport.com/mbt-chapa-gtx-shoes-c-1_3.html" target="_blank" title="MBT Chapa GTX Shoes">MBT Chapa GTX Shoes</a> <a href="http://www.mbtshoesport.com/mbt-lami-shoes-c-2_10.html" target="_blank" title="MBT Lami Shoes">MBT Lami Shoes</a> <a href="http://www.mbtshoesport.com/mbt-mwalk-shoes-c-1_4.html" target="_blank" title="MBT M.Walk Shoes">MBT M.Walk Shoes</a> <a href="http://www.mbtshoesport.com/munich-men-shoes-c-23.html" target="_blank" title="Munich Men Shoes">Munich Men Shoes</a> <a href="http://www.mbtshoesport.com/munich-women-shoes-c-24.html" target="_blank" title="Munich Women Shoes">Munich Women Shoes</a>