Re: New to PostgreSQL, performance considerations

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: New to PostgreSQL, performance considerations
Дата
Msg-id 5202.1165944751@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: New to PostgreSQL, performance considerations  ("Daniel van Ham Colchete" <daniel.colchete@gmail.com>)
Список pgsql-performance
"Daniel van Ham Colchete" <daniel.colchete@gmail.com> writes:
> I'm making some other tests here at another hardware (also Gentoo). I
> found out that PostgreSQL stops for a while if I change the -t
> parameter on bgbench from 600 to 1000 and I have ~150 tps instead of
> ~950tps.

> I don't know why PostgreSQL stoped, but it was longer than 5 seconds
> and my disk IO was comsuming 100% of my CPU time during this period.

Checkpoint?

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: New to PostgreSQL, performance considerations
Следующее
От: Ron
Дата:
Сообщение: Re: New to PostgreSQL, performance considerations