| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | "Nurlan Mukhanov (AL/EKZ)" <Nurlan(dot)Mukhanov(at)ericsson(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Postgresql works too slow |
| Date: | 2005-04-19 14:46:33 |
| Message-ID: | 1113921994.16721.2162.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice pgsql-performance |
On Mon, 2005-04-18 at 08:50 +0400, Nurlan Mukhanov (AL/EKZ) wrote:
> I'm trying to restore my database from dump in several parrallel processes, but restore process works too slow.
> Number of rows about 100 000 000,
> RAM: 8192M
> CPU: Ultra Sparc 3
> Number of CPU: 4
> OS: SunOS sun 5.8
> RDBMS: PostgreSQL 8.0
> How to encrease postgresql speed? Why postgres took only 5.0% of CPU time?
When you say restore...what are you actually doing?
An archive recovery?
A reload?
A file-level restore of database?
Best Regards, Simon Riggs
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brad Nicholson | 2005-04-19 15:06:35 | Re: Postgresql works too slow |
| Previous Message | Jeff Eckermann | 2005-04-19 13:59:19 | Re: records chaining |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brad Nicholson | 2005-04-19 15:06:35 | Re: Postgresql works too slow |
| Previous Message | Mohan, Ross | 2005-04-19 14:34:51 | Re: How to improve db performance with $7K? |