Re: Performance problems with Postgresql/ZFS/Non-global zones on Solaris?

Поиск
Список
Период
Сортировка
От jiniusatwork-postgresql@yahoo.com
Тема Re: Performance problems with Postgresql/ZFS/Non-global zones on Solaris?
Дата
Msg-id 307025.78124.qm@web43134.mail.sp1.yahoo.com
обсуждение исходный текст
Ответ на Performance problems with Postgresql/ZFS/Non-global zones on Solaris?  (jiniusatwork-postgresql@yahoo.com)
Список pgsql-general
 
Don't even bother trying to tune zfs untill after you've tuned postgres,
otherwise your wasting your time.

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

As it turns out, I think the ZFS-on-RAID setup I had is the problem[1]. After running some more I/O tests with "fsync" turned on, I noticed that filesystem "writes" were about 400% slower. Running PostgreSQL without "fsync" made the application run about 1.5 times faster on ZFS versus UFS. So, now it's back to the drawing board to figure out if I can make the synchronous writes faster.
 
Bob
[1] the suggestions made previously helped a bit, but not nearly enough to overcome the 50% drop originally noted.
 

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

Предыдущее
От: "Brian A. Seklecki (Mobile)"
Дата:
Сообщение: Re: PostgreSQL/PHP Application Server
Следующее
От: Sim Zacks
Дата:
Сообщение: temp sequence