Re: SQL Server performing much better?!?!

Поиск
Список
Период
Сортировка
От Holger Marzen
Тема Re: SQL Server performing much better?!?!
Дата
Msg-id Pine.LNX.4.44.0203242120250.23350-100000@bluebell.marzen.de
обсуждение исходный текст
Ответ на Re: SQL Server performing much better?!?!  (Mark kirkwood <markir@slingshot.co.nz>)
Список pgsql-general
On 25 Mar 2002, Mark kirkwood wrote:

> Agreed...I currently work with Solaris and its generally quite good...
> but there seems to be a definite performance problem with Postgresql on
> Solaris (see a previous thread with title "Solaris Performance").

Solaris is slow when writing to ufs filesystem in default configuration.
I guess that postgresql writes out temporary data. The writes can
probably be speed up when writing to tempfs or by disabling the journal.

Writing data can probably speed up with the mount option "nologging".
Reading data can probably speed up with the mount option "noatime".

Can someone try this?

--
PGP/GPG Key-ID:
http://blackhole.pca.dfn.de:11371/pks/lookup?op=get&search=0xB5A1AFE1


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Large Object Location in 7.3
Следующее
От: Richard Emberson
Дата:
Сообщение: Re: Large Object Location in 7.3