Re: Optimize

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: Optimize
Дата
Msg-id 87fzgdnq1e.fsf@mailbox.samurai.com
обсуждение исходный текст
Ответ на Optimize  (Torsten Schulz <comic@be-a-part.de>)
Список pgsql-performance
Torsten Schulz <comic@be-a-part.de> writes:
> Our Server:
> Dual-CPU with 1.2 GHz
> 1.5 GB RAM

What kind of I/O subsystem is in this machine? This is an x86 machine,
right?

> Has anyone an idea what's the best configuration for thta server?

It is difficult to say until you provide some information on the
system's state during periods of heavy traffic.

BTW, in addition to the machine's hardware configuration, have you
looked at tuning the queries running on PostgreSQL? What about the OS
kernel?

-Neil


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

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: Maximum Possible Insert Performance?
Следующее
От: Neil Conway
Дата:
Сообщение: Re: VACUUM problems with 7.4