Re: Abnormal performance difference between Postgres and MySQL
| От | Farhan Husain |
|---|---|
| Тема | Re: Abnormal performance difference between Postgres and MySQL |
| Дата | |
| Msg-id | 3df32b6d0902251244t416c0c68p37833891bb908045@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Abnormal performance difference between Postgres and MySQL (Robert Haas <robertmhaas@gmail.com>) |
| Ответы |
Re: Abnormal performance difference between Postgres and
MySQL
|
| Список | pgsql-performance |
On Wed, Feb 25, 2009 at 1:52 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> 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
Initially, it was the default value (32MB). Later I played with that value thinking that it might improve the performance. But all the values resulted in same amount of time.
--
Mohammad Farhan Husain
Research Assistant
Department of Computer Science
Erik Jonsson School of Engineering and Computer Science
University of Texas at Dallas
В списке pgsql-performance по дате отправления: