pg_restore performance on solaris 10/6

Поиск
Список
Период
Сортировка
От Thomas Burns
Тема pg_restore performance on solaris 10/6
Дата
Msg-id 80EA80DA-B70D-4603-866B-D728E2E52A93@schoolloop.com
обсуждение исходный текст
Ответы Re: pg_restore performance on solaris 10/6
Список pgsql-general
Hi,

We recently started using a Sun x4200 with Solaris 10/6 (the release
from jun of 2006) and postgresql 8.1.3.  I think I may need to do some
tuning, but have no idea what to change.  Using pg_restore to restore
our database literally takes 8 times longer on the x4200 as it does on
OS X (the x4200 hardware should be considerably faster -- it has better
drives, more RAM, faster processors and 4 cores vs 2 cores).  The
loadavg
on the x4200 during the restore is extremely low -- about 0.01 (on OS X,
it would be more like 1.5 or 2.0).  Any idea what could be going on?

Thanks,
Tom Burns



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Triggers in Postgres
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Unicode sorting problem