Re: Performance of pg_dump on PGSQL 8.0

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "John Vincent" <pgsql-performance(at)lusis(dot)org>
Cc: "Scott Marlowe" <smarlowe(at)g2switchworks(dot)com>, "PGSQL Performance" <pgsql-performance(at)postgresql(dot)org>, "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
Subject: Re: Performance of pg_dump on PGSQL 8.0
Date: 2006-06-16 01:03:56
Message-ID: b42b73150606151803y64edcd15t30ec3a5e9d261e4c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Just couple of suggestions:

I think on the current server you're pretty much hosed since you are
look like you are cpu bottlenecked. You probably should take a good
look at PITR and see if that meets your requirements. Also you
definately want to go to 8.1...it's faster, and every bit helps.

Good luck with the new IBM server ;)

merlin

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Qingqing Zhou 2006-06-16 01:34:12 Re: Test request for Stats collector performance improvement
Previous Message Mischa Sandberg 2006-06-16 00:36:22 Re: Optimizer internals