Re: Simple postgresql.conf wizard
От | Robert Haas |
---|---|
Тема | Re: Simple postgresql.conf wizard |
Дата | |
Msg-id | 603c8f070812032201id37d3a0l51190c207a781744@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Simple postgresql.conf wizard ("Mark Wong" <markwkm@gmail.com>) |
Список | pgsql-hackers |
>> I think the tests you could consider next is to graph the target going from >> 10 to 100 in steps of 10 just for those 5 queries. If it gradually >> degrades, that's interesting but hard to nail down. But if there's a sharp >> transition, getting an explain plan for the two sides of that should provide >> some insight. I'm really more interested in the ones that slowed down than >> the one that improved, understanding that might finally provide some >> evidence against increasing it by default. > > I've updated the charts to include results from setting > default_statistics_target from 20-90. The links to the charts are the > same. The links to the raw data are in > http://207.173.203.223/~markwkm/community6/dbt3/ in directories 45-52. I still think we're missing the boat here because it's not really the same query every time. ...Robert
В списке pgsql-hackers по дате отправления: