On Thu, Dec 27, 2007 at 01:14:25PM +, Gregory Stark wrote:
> "Jared Mauch" <[EMAIL PROTECTED]> writes:
>
> > pg_dump is utilizing about 13% of the cpu and the
> > corresponding postgres backend is at 100% cpu time.
> > (multi-core, multi-cpu, lotsa ram, super-fast disk).
> >...
> > pg8
"Jared Mauch" <[EMAIL PROTECTED]> writes:
> pg_dump is utilizing about 13% of the cpu and the
> corresponding postgres backend is at 100% cpu time.
> (multi-core, multi-cpu, lotsa ram, super-fast disk).
>...
> pg8.3(beta) with the following variances from default
>
> checkpoint_segment
On Wed, Dec 26, 2007 at 11:35:59PM +0200, Heikki Linnakangas wrote:
> I run a quick oprofile run on my laptop, with a table like that, filled
> with dummy data. It looks like indeed ~30% of the CPU time is spent in
> sprintf, to convert the integers and inets to string format. I think you
> coul
Jared Mauch wrote:
On Wed, Dec 26, 2007 at 10:52:08PM +0200, Heikki Linnakangas wrote:
Jared Mauch wrote:
pg_dump is utilizing about 13% of the cpu and the
corresponding postgres backend is at 100% cpu time.
(multi-core, multi-cpu, lotsa ram, super-fast disk).
...
Any tips on getting p
On Wed, Dec 26, 2007 at 10:52:08PM +0200, Heikki Linnakangas wrote:
> Jared Mauch wrote:
>> pg_dump is utilizing about 13% of the cpu and the
>> corresponding postgres backend is at 100% cpu time.
>> (multi-core, multi-cpu, lotsa ram, super-fast disk).
>> ...
>> Any tips on getting pg_dum
Jared Mauch wrote:
pg_dump is utilizing about 13% of the cpu and the
corresponding postgres backend is at 100% cpu time.
(multi-core, multi-cpu, lotsa ram, super-fast disk).
...
Any tips on getting pg_dump (actually the backend) to perform
much closer to 500k/sec or more? This would al
I gmane.comp.db.postgresql.performance, skrev Christopher Kings-Lynne:
> Is it the dump or the restore that's really slow?
Primarily the dump, it seems to be CPU-bound on the postmaster' process.
No signs on IO-bottleneck when I try to monitor with iostat or vmstat
--
./Jesper Krogh, [EMAIL P
Is it the dump or the restore that's really slow?
Chris
Jesper Krogh wrote:
I have a database that I should migrate from 7.3 -> 7.4.3 but pg_dump |
psql seems to take forever. (Several hours) Is there anything that can I
do to speed it up?
The databse is primary a table with 300.000 records of ab