Re: [GENERAL] speed up restore from dump

2008-11-01 Thread Robert Treat
On Friday 31 October 2008 08:07:08 Sam Mason wrote: On Thu, Oct 30, 2008 at 02:28:38PM -0700, Alan Hodgson wrote: On Thursday 30 October 2008, Joao Ferreira [EMAIL PROTECTED] wrote: well. see for yourself... (360 RAM , 524 SWAP) that's what it is... it supposed to be somewhat an

Re: [GENERAL] speed up restore from dump

2008-10-31 Thread Sam Mason
On Thu, Oct 30, 2008 at 02:28:38PM -0700, Alan Hodgson wrote: On Thursday 30 October 2008, Joao Ferreira [EMAIL PROTECTED] wrote: well. see for yourself... (360 RAM , 524 SWAP) that's what it is... it supposed to be somewhat an embedded product... Clearly your hardware is your speed

Re: [GENERAL] speed up restore from dump

2008-10-31 Thread Joao Ferreira
On Thu, 2008-10-30 at 13:08 -0700, Alan Hodgson wrote: On Thursday 30 October 2008, Joao Ferreira gmail During restore: # vmstat procs memory--- ---swap-- -io -system-- cpu r b swpd free buff cache si so bi bo in cs us sy id wa 3 1 230204

[GENERAL] speed up restore from dump

2008-10-30 Thread Joao Ferreira gmail
Hello all, I've been tring to speed up the restore operation of my database without success. I have a 200MB dump file obtained with 'pg_dumpall --clean --oids'. After restore is produces a database with one single table (1.000.000) rows. I have also some indexes on that table. that's it. It

Re: [GENERAL] speed up restore from dump

2008-10-30 Thread Alan Hodgson
On Thursday 30 October 2008, Joao Ferreira gmail [EMAIL PROTECTED] wrote: What other cfg paramenters shoud I touch ? work_mem set to most of your free memory might help. You're probably just disk-bound, though. What does vmstat say during the restore? -- Alan -- Sent via pgsql-general

Re: [GENERAL] speed up restore from dump

2008-10-30 Thread Joao Ferreira gmail
On Thu, 2008-10-30 at 11:39 -0700, Alan Hodgson wrote: On Thursday 30 October 2008, Joao Ferreira gmail [EMAIL PROTECTED] wrote: What other cfg paramenters shoud I touch ? work_mem set to most of your free memory might help. I've raised work_mem to 128MB. still get the same 20 minutes

Re: [GENERAL] speed up restore from dump

2008-10-30 Thread Sam Mason
On Thu, Oct 30, 2008 at 07:28:57PM +, Joao Ferreira gmail wrote: On Thu, 2008-10-30 at 11:39 -0700, Alan Hodgson wrote: You're probably just disk-bound, though. What does vmstat say during the restore? During restore: # vmstat procs memory--- ---swap-- -io

Re: [GENERAL] speed up restore from dump

2008-10-30 Thread Alan Hodgson
On Thursday 30 October 2008, Joao Ferreira gmail During restore: # vmstat procs memory--- ---swap-- -io -system-- cpu r b swpd free buff cache si so bi bo in cs us sy id wa 3 1 230204 4972 1352 110128 21 17 63 24 56 12 2 85 0 #

Re: [GENERAL] speed up restore from dump

2008-10-30 Thread Alvaro Herrera
Alan Hodgson wrote: On Thursday 30 October 2008, Joao Ferreira gmail During restore: # vmstat procs memory--- ---swap-- -io -system-- cpu r b swpd free buff cache si so bi bo in cs us sy id wa 3 1 230204 4972 1352 110128 21 17

Re: [GENERAL] speed up restore from dump

2008-10-30 Thread Alan Hodgson
On Thursday 30 October 2008, Joao Ferreira [EMAIL PROTECTED] wrote: well. see for yourself... (360 RAM , 524 SWAP) that's what it is... it supposed to be somewhat an embedded product... Clearly your hardware is your speed limitation. If you're swapping at all, anything running on the