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 t

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

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 yo

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

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 2

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

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 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 m

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 ma

[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 alwa