On 01/03/2013, at 10.52, Steven Crandell <steven.crandell@xxxxxxxxx> wrote: > Recently I moved my ~600G / ~15K TPS database from a > 48 core@2.0GHz server with 512GB RAM on 15K RPM disk > to a newer server with > 64 core@2.2Ghz server with 1T of RAM on 15K RPM disks > > The move was from v9.1.4 to v9.1.8 (eventually also tested with v9.1.4 on the new hardware) and was done via base backup followed by slave promotion. > All postgres configurations were matched exactly as were system and kernel parameters. > my guess is that you have gone down in clockfrequency on memory when you doubled the amount of memory in a mainly memory cached database the performance is extremely sensitive to memory speed Jesper -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
