Re: Postgresql works too slow

Список
Период
Сортировка
От Brad Nicholson
Тема Re: Postgresql works too slow
Дата
Msg-id 42651E7B.7080702@ca.afilias.info
обсуждение исходный текст
Ответ на Re: Postgresql works too slow  (Simon Riggs)
Список 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.


В списке pgsql-performance по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Postgresql works too slow
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Question on REINDEX