On Fri, Jun 7, 2013 at 3:14 PM, Kevin Grittner <kgri...@ymail.com> wrote: > Some findings were unsurprising, like that a direct connection > between the servers using a cross-wired network patch cable was > faster than plugging both machines into the same switch. But we > tested all of our assumptions, and re-tested the surprising ones. > One such surprise was that the conversion ran faster, even on a > "largish" database of around 200GB, with 3 checkpoint_segments than > with larger settings.
! I can't account for that finding, because my experience is that small checkpoint_segments settings lead to *terrible* bulk restore performance. *scratches head* -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers