Re: Most effective tuning choices for busy website?

Поиск
Список
Период
Сортировка
От Christopher Weimann
Тема Re: Most effective tuning choices for busy website?
Дата
Msg-id 20050614235937.GA97567@tektite.k12usa.internal
обсуждение исходный текст
Ответ на Most effective tuning choices for busy website?  (Mark Stosberg <mark@summersault.com>)
Список pgsql-performance
On 06/01/2005-07:19PM, Mark Stosberg wrote:
>
>  - I saw the hardware tip to "Separate the Transaction Log from the
>    Database". We have about 60% SELECT statements and 14% UPDATE
>    statements. Focusing more on SELECT performance seems more important
>    for us.
>

I would think that would help SELECT If the spindle isn't busy writing
Transaction log it can be reading for your SELECTs.

You did say you were CPU bound though.

--
------------------------------------------------------------
Christopher Weimann
http://www.k12usa.com
K12USA.com Cool Tools for Schools!
------------------------------------------------------------

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

Предыдущее
От: "Ken Shaw"
Дата:
Сообщение: How to determine whether to VACUUM or CLUSTER
Следующее
От: Alex Turner
Дата:
Сообщение: Re: Multiple disks: RAID 5 or PG Cluster