Postgresql works too slow
От | Nurlan Mukhanov (AL/EKZ) |
---|---|
Тема | Postgresql works too slow |
Дата | |
Msg-id | 70E6659A9338D8418379B4EC0CA5819137928D@erumomw002.eemea.ericsson.se обсуждение исходный текст |
Ответы |
Re: Postgresql works too slow
Re: Postgresql works too slow |
Список | pgsql-performance |
Hello. 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 ==================== prstat info ==================== PID USERNAME SIZE RSS STATE PRI NICE TIME CPU PROCESS/NLWP 14231 postgres 41M 37M sleep 58 0 0:00.01 0.2% postgres/1 14136 postgres 41M 37M sleep 58 0 0:00.03 0.2% postgres/1 14211 postgres 41M 37M sleep 58 0 0:00.01 0.2% postgres/1 14270 postgres 41M 37M sleep 58 0 0:00.00 0.2% postgres/1 13767 postgres 41M 37M sleep 58 0 0:00.18 0.2% postgres/1 13684 postgres 41M 36M sleep 58 0 0:00.14 0.2% postgres/1 NPROC USERNAME SIZE RSS MEMORY TIME CPU 74 root 272M 191M 2.3% 0:26.29 24% 124 postgres 1520M 1306M 16% 0:03.05 5.0% How to encrease postgresql speed? Why postgres took only 5.0% of CPU time? Nurlan Mukhanov
В списке pgsql-performance по дате отправления: