Re: postgres load

Поиск
Список
Период
Сортировка
От Denis Perchine
Тема Re: postgres load
Дата
Msg-id 01022114475102.02238@dyp.perchine.com
обсуждение исходный текст
Ответ на RE: postgres load  ("Joseph" <lters@mrtc.com>)
Список pgsql-general
On Wednesday 21 February 2001 01:19, Joseph wrote:
> I republish my question for I had no answer, and this is a serious
> problem to me... I've used explain, vacuum, indexes... and so on, few
> nested requests...

Do not use ReiserFS on production machines. There are still enormous amount
of bugs includig data corruption, etc. See recent linux-kernel discussions
for details. That's why what you expiriencing is possible.

> ----
> I am running PGSql 7.0.3 over Linux 2/ELF with a ReiserFS
> filesystem,
> Bi-P3 800 and 2Gb of RAM.
>
>         My database jump from 8 in load to 32 without any real reason
> nor too
> much requests.
>
>         I already do vacuum even on the fly ifever that can decrease
> load, but
> nothing...
>
>         I've done many indexed also...
>
>         Can someone help me ?
>
>                 Emmanuel

--
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------

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

Предыдущее
От: "Andrey Y. Mosienko"
Дата:
Сообщение: How to release SET() in PgSQL?
Следующее
От: Pete Forman
Дата:
Сообщение: Re: vacuum analyze again...