Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
| От | Pietro Pugni |
|---|---|
| Тема | Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL |
| Дата | |
| Msg-id | 4D51FE53-2614-4D5E-8657-79485BF7D6E0@gmail.com обсуждение исходный текст |
| Ответ на | Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL (Josh Krupka <jkrupka@gmail.com>) |
| Ответы |
Re: Can't get Dell PE T420 (Perc H710) perform better than
a MacMini with PostgreSQL
|
| Список | pgsql-performance |
Hi Josh,
Did you already post the results of:cat /proc/sys/vm/zone_reclaim_mode
zone_reclaim_mode was set on 0 for all my tests. I’ve also set it to the other values (1, 2, 4) but there was no improvement. Tests results are the following (1 run for each test):
echo 0 > /proc/sys/vm/zone_reclaim_mode
130s
echo 1 > /proc/sys/vm/zone_reclaim_mode
129s
echo 2 > /proc/sys/vm/zone_reclaim_mode
134s
echo 4 > /proc/sys/vm/zone_reclaim_mode
131s
Also, how big did you say your dataset is? Based on the output of free, you're certainly not using all the memory you have. That could be just because you haven't accessed that much of your dataset, or it could be because zone reclaim is preventing you from using your entire amount of RAM as file system cache.
Thank you for your help.
Best regards,
Pietro
В списке pgsql-performance по дате отправления: