| From: | Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Postgresql works too slow |
| Date: | 2005-04-19 15:06:35 |
| Message-ID: | 42651E7B.7080702@ca.afilias.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice pgsql-performance |
Simon Riggs wrote:
>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?
>
>
>
If you are doing a restore off a pg_dump, did you dump the data as
inserts? This takes a lot more time to restore.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Depero | 2005-04-19 15:35:05 | problem migratin from ms sql |
| Previous Message | Simon Riggs | 2005-04-19 14:46:33 | Re: Postgresql works too slow |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2005-04-19 15:57:16 | Re: Question on REINDEX |
| Previous Message | Simon Riggs | 2005-04-19 14:46:33 | Re: Postgresql works too slow |