On Thu, Aug 18, 2011 at 11:55 PM, Midge Brown <midgems@xxxxxxxxxxxxx> wrote: > I'm in the process of upgrading from postgres 7.4.8 to 9.0.4 and wanted to > run my decisions past some folks who can give me some input on whether my > decisions make sense or not. I am not sure what decisions you actually refer to here: in your posting I can only see description of the current setup but no decisions for the upgrade (i.e. changed parameters, other physical layout etc.). > The others are very write-heavy, started as one table within the original > DB, and were split out on an odd/even id # in an effort to get better > performance: Did it pay off? I mean you planned to increase performance and did this actually happen? Apart from reserving IO bandwidth (which you achieved by placing data on different disks) you basically only added reserved memory for each instance by separating them. Or are there any other effects achieved by separating (like reduced lock contention on some globally shared resource, distribution of CPU for logging)? Kind regards robert -- remember.guy do |as, often| as.you_can - without end http://blog.rubybestpractices.com/ -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
