Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group