Re: PostgreSQL calibration

Поиск
Список
Период
Сортировка
От matt
Тема Re: PostgreSQL calibration
Дата
Msg-id 1055957804.3900.52.camel@gibraltar.mattclark.net
обсуждение исходный текст
Ответ на Re: PostgreSQL calibration  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: PostgreSQL calibration  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список pgsql-admin
Are there really any performance settings of much interest beyond the
shared and non-shared memory settings?  Beyond those the interactions
get so complex that automation is probably impossible anyway, and
certain options like fsync = false should never be 'recommended'.

On the other hand, a way of empirically deriving some 'correct'
optimizer parameters for a given machine would be very nice :-)


Matt


On Wed, 2003-06-18 at 18:07, Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Sure, it would be great if we could do it.
>
> If the program actually derives reliable numbers, it would be great.
> It could easily do more harm than good if it gives bogus results.
> I think it will be very hard to get reliable rather than bogus results
> :-( ... but feel free to try.
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: postgreSQL 7.3.3 crashing on server with Itanium processor...
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Perl DBI question