Hi all, I recently ran a couple of tests where I took one of my production systems and did a drop-in replacement of postgres 8.4 with 9.2.4. I was expecting to see some performance improvement given the release notes describing 9.2 as a "largely performance related release".
At least for my application, which is an embedded postgresql install with a relatively small number of client connections, I'm not seeing much of a measurable difference at all. I'm just wondering if others have had a similar experience where upgrading from 8.x to 9.x has or has not improved overall performance? Thanks.