Re: [PERFORM] 7.3.2 pg_restore very slow

From: Saranya Sivakumar <sarlavk(at)yahoo(dot)com>
To: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>, pgsqlnovice <pgsql-novice(at)postgresql(dot)org>, pgsqlperform <pgsql-performance(at)postgresql(dot)org>
Subject: Re: [PERFORM] 7.3.2 pg_restore very slow
Date: 2006-08-07 20:07:40
Message-ID: 20060807200740.93954.qmail@web51315.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice pgsql-performance

Hi All,

Thanks Richard for the additional link. The information is very useful.

The restore completed successfully in 2.5 hours in the new 2GB box, with the same configuration parameters. I think if I can tweak the parameters a little more, I should be able to get it down to the 1 hr down time that we can afford.

Thanks again for all the help.

Sincerely,
Saranya

Richard Broersma Jr <rabroersma(at)yahoo(dot)com> wrote:
> Thank you very much for the information. The SHMMAX was set to 33554432, and that's why it
> failed to start the postmaster. Thanks for the link to the kernel resources article. I guess
> changing these parameters would require recompiling the kernel.
>
> Is there any work around without changing these parameters to make maximum use of RAM?
>
> We got a new server now with 2GB RAM, but it also has the same value for SHMMAX.
>
> And I am trying the restore with the following conf
> sort_mem = 40960 (changed from 1024)
> shared_buffers = 3000 (changed from 64)
> max_connections = 128 (changed from 32)

This is one of the best links that I can give you in addition to the Postgresql Kernel resource
link.
http://www.powerpostgresql.com/PerfList

I am pretty much a beginner at resource tuning also. In fact, after googling for sources that
describe how to tune kernel parameters, the postgresql documents remains the best documents I've
found so far.

I would be interested if anyone else on the list knows of any resources or books that have an in
depth discussion on methods/strategies to tune kernel parameters to maximized usage of system
resources and at the same time allow for harmonious sharing between various programs/services.

Regards,

Richard Broersma Jr.


---------------------------------
Want to be your own boss? Learn how on Yahoo! Small Business.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Richard Broersma Jr 2006-08-07 23:57:38 Re: Cannot connect though socket
Previous Message Richard Broersma Jr 2006-08-07 19:18:56 Re: [PERFORM] 7.3.2 pg_restore very slow

Browse pgsql-performance by date

  From Date Subject
Next Message Steinar H. Gunderson 2006-08-07 20:20:02 Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig
Previous Message Alex Turner 2006-08-07 20:02:52 Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig