Re: PostgreSQL Configuration Tool for Dummies

Поиск
Список
Период
Сортировка
От david@lang.hm
Тема Re: PostgreSQL Configuration Tool for Dummies
Дата
Msg-id Pine.LNX.4.64.0706191159081.25045@asgard.lang.hm
обсуждение исходный текст
Ответ на Re: PostgreSQL Configuration Tool for Dummies  ("Y Sidhu" <ysidhu@gmail.com>)
Список pgsql-performance
On Tue, 19 Jun 2007, Y Sidhu wrote:

> On 6/19/07, Francisco Reyes <lists@stringsutils.com> wrote:
>>
>>  Campbell, Lance writes:
>>
>> >  Francisco and Richard,
>> >  Why ask about disk or raid?  How would that impact any settings in
>> >  postgresql.conf?
>>
>>  If the user has 2 disks and says that he will do a lot of updates he could
>>  put pg_xlog in the second disk.
>>
>>
>>  ---------------------------(end of broadcast)---------------------------
>>  TIP 2: Don't 'kill -9' the postmaster
>>
>
> Let's not ask about disk or raid at this level of sanity tuning. It is
> important for a newbie to take the right first step. When it comes to disks,
> we start talking I/O, SATA, SCSI and the varying degrees of SATA and SCSI,
> and controller cards. Then we throw in RAID and the different levels
> therein. Add to that, we can talk about drivers controlling these drives and
> which OS is faster, more stable, etc. As you can see, a newbie would get
> drowned. So, please keep it simple. I know many people on this list are
> Gurus. We know you are the best in this field, but we are not and are just
> trying to improve what we have.

I strongly agree.

besides, the number and types of drives, raid configurations, etc is so
variable that I strongly believe that the right answer is going to be
something along the lines of 'run this tool and then enter the number(s)
that the tool reports' and then let the tool measure the end result of all
the variables rather then trying to calculate the results.

David Lang

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

Предыдущее
От: Francisco Reyes
Дата:
Сообщение: Re: PostgreSQL Configuration Tool for Dummies
Следующее
От: david@lang.hm
Дата:
Сообщение: Re: PostgreSQL Configuration Tool for Dummies