Re: [HACKERS] WIP parallel restore patch

2008-11-20 Thread Kenneth Marshall
On Thu, Nov 20, 2008 at 02:26:14PM -0500, Andrew Dunstan wrote: > > > Kenneth Marshall wrote: >> Okay, I have had a chance to run some timing benchmarks. >> Here are my results for the parallel pg_restore patch: >> >> Ken >> -- >> Server settings: >>

Re: [HACKERS] WIP parallel restore patch

2008-11-20 Thread Andrew Dunstan
Kenneth Marshall wrote: Okay, I have had a chance to run some timing benchmarks. Here are my results for the parallel pg_restore patch: Ken -- Server settings: max_connections = 100 # (change requires restart) shared_buff

Re: [HACKERS] WIP parallel restore patch

2008-11-20 Thread Kenneth Marshall
Okay, I have had a chance to run some timing benchmarks. Here are my results for the parallel pg_restore patch: Ken -- Server settings: max_connections = 100 # (change requires restart) shared_buffers = 256MB

Re: [HACKERS] WIP parallel restore patch

2008-11-20 Thread Andrew Dunstan
Magnus Hagander wrote: Andrew Dunstan wrote: Attached is my latest parallel restore patch. I think it's functionally complete for Unix. Many bugs have been fixed since the last patch, and the hardcoded limitation to two table dependencies is removed. It seems fairly robust in my recent tes

Re: [HACKERS] WIP parallel restore patch

2008-11-20 Thread Magnus Hagander
Andrew Dunstan wrote: > > Attached is my latest parallel restore patch. I think it's functionally > complete for Unix. > > Many bugs have been fixed since the last patch, and the hardcoded > limitation to two table dependencies is removed. It seems fairly robust > in my recent testing. > > Remai

Re: [HACKERS] WIP parallel restore patch

2008-11-05 Thread Andrew Dunstan
Stefan Kaltenbrunner wrote: Andrew Dunstan wrote: Attached is my latest parallel restore patch. I think it's functionally complete for Unix. Many bugs have been fixed since the last patch, and the hardcoded limitation to two table dependencies is removed. It seems fairly robust in my rec

Re: [HACKERS] WIP parallel restore patch

2008-11-05 Thread Stefan Kaltenbrunner
Andrew Dunstan wrote: Attached is my latest parallel restore patch. I think it's functionally complete for Unix. Many bugs have been fixed since the last patch, and the hardcoded limitation to two table dependencies is removed. It seems fairly robust in my recent testing. this version see

[HACKERS] WIP parallel restore patch

2008-10-29 Thread Andrew Dunstan
Attached is my latest parallel restore patch. I think it's functionally complete for Unix. Many bugs have been fixed since the last patch, and the hardcoded limitation to two table dependencies is removed. It seems fairly robust in my recent testing. Remaining to be done: . code cleanup .