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
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
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
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
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
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
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
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
#
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
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
10 matches
Mail list logo