Re: Abnormal performance difference between Postgres and MySQL

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Abnormal performance difference between Postgres and MySQL
Дата
Msg-id 603c8f070902251152s67ed8353v29f41f8e413e259d@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Abnormal performance difference between Postgres and MySQL  (Farhan Husain <russoue@gmail.com>)
Ответы Re: Abnormal performance difference between Postgres and MySQL  (Farhan Husain <russoue@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
> Please note that this (1792MB) is the highest that I could set for work_mem.

Yeah, that's almost certainly part of your problem.

You need to make that number MUCH smaller.  You probably want a value
like 1MB or 5MB or maybe if you have really a lot of memory 20MB.

That's insanely high.

...Robert

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

Предыдущее
От: Scott Carey
Дата:
Сообщение: Re: PostgreSQL block size for SSD RAID setup?
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Abnormal performance difference between Postgres and MySQL