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

Re: Should pg_dump dump larger tables first?

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Should pg_dump dump larger tables first?
Date: 2013-01-31 10:15:01
Message-ID: 510A4425.4090608@hogranch.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On 1/31/2013 2:06 AM, Dimitri Fontaine wrote:
> Loading several big'o'tables in parallel tend not to give benefits in
> the tests I've done so far, but that might be an artefact of python
> multi threading, I will do some testing with proper tooling later.

or insufficient IO parallelism in your disk hardware, file system, etc.



-- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast



In response to

pgsql-hackers by date

Next:From: Bernd HelmleDate: 2013-01-31 10:56:15
Subject: Re: pgsql: Improve concurrency of foreign key locking
Previous:From: Dimitri FontaineDate: 2013-01-31 10:06:24
Subject: Re: Should pg_dump dump larger tables first?

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