Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Benchmark Data requested
- From: Simon Riggs <simon(at)2ndquadrant(dot)com>
- To: "Jignesh K. Shah" <J(dot)K(dot)Shah(at)Sun(dot)COM>
- Cc: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>, Dimitri Fontaine <dfontaine(at)hi-media(dot)com>, pgsql-performance(at)postgresql(dot)org, Greg Smith <gsmith(at)gregsmith(dot)com>
- Subject: Re: Benchmark Data requested
- Date: Tue, 05 Feb 2008 22:00:03 +0000
On Tue, 2008-02-05 at 15:50 -0500, Jignesh K. Shah wrote: > Is there a way such an operation can be spawned as a worker process? > Generally during such loading - which most people will do during > "offpeak" hours I expect additional CPU resources available. By > delegating such additional work to worker processes, we should be able > to capitalize on additional cores in the system. > > Even if it is a single core, the mere fact that the loading process will > eventually wait for a read from the input file which cannot be > non-blocking, the OS can timeslice it well for the second process to use > those wait times for the index population work. If Dimitri is working on parallel load, why bother? -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com
- Follow-Ups:
- Re: Benchmark Data requested
- From: Greg Smith
- Re: Benchmark Data requested
- References:
- Benchmark Data requested
- From: Simon Riggs
- Re: Benchmark Data requested
- From: Dimitri Fontaine
- Re: Benchmark Data requested
- From: Simon Riggs
- Re: Benchmark Data requested
- From: Dimitri Fontaine
- Re: Benchmark Data requested
- From: Heikki Linnakangas
- Re: Benchmark Data requested
- From: Jignesh K. Shah
- Benchmark Data requested
- Prev by Date: Re: Benchmark Data requested
- Next by Date: Re: Benchmark Data requested
- Previous by thread: Re: Benchmark Data requested
- Next by thread: Re: Benchmark Data requested
- Indexes: