Re: Plz Heeeelp! performance settings

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Plz Heeeelp! performance settings
Дата
Msg-id b42b73150808061916j74fd5334y318ef3819fa49ea8@mail.gmail.com
обсуждение исходный текст
Ответ на Plz Heeeelp! performance settings  (dforum <dforums@vieonet.com>)
Ответы Re: Plz Heeeelp! performance settings  (dforum <dforums@vieonet.com>)
Список pgsql-performance
On Wed, Aug 6, 2008 at 6:12 PM, dforum <dforums@vieonet.com> wrote:
> Hello to all,
>
>
> I have a Linux 2.6.24.2-xxxx-std-ipv4-64 #3 SMP Tue Feb 12 12:27:47 CET 2008
> x86_64 Intel(R) Xeon(R) CPU X5355 @ 2.66GHz GenuineIntel GNU/Linux
> with 8Gb of memory. Using sata II disk in RAID 1 (I known that is bad, but
<snip>

this is likely your problem...with fsync on (as you have it), you will
be lucky to get a couple of hundred transactions/sec out of the
database.  you are probably just exceeding your operational
capabilities of the hardware so you probably need to upgrade or turn
off fsync (which means data corruption in event of hard crash).

merlin

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

Предыдущее
От: Mark Kirkwood
Дата:
Сообщение: Re: file system and raid performance
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: query planner not using the correct index