Re: That EXPLAIN ANALYZE patch still needs work
От | Tom Lane |
---|---|
Тема | Re: That EXPLAIN ANALYZE patch still needs work |
Дата | |
Msg-id | 1251.1149800287@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: That EXPLAIN ANALYZE patch still needs work (Simon Riggs <simon@2ndquadrant.com>) |
Ответы |
Re: That EXPLAIN ANALYZE patch still needs work
Re: That EXPLAIN ANALYZE patch still needs work Re: That EXPLAIN ANALYZE patch still needs work |
Список | pgsql-hackers |
Simon Riggs <simon@2ndquadrant.com> writes: > So the timing is clearly responsible for the additional time I'm > personally experiencing and very likely to be that for others also. Well, that's certainly unsurprising, but the question is why it's such a large overhead for you when it's not on other apparently-similar kit. If anyone else is still following this discussion, could you try the test case Simon gave a bit earlier (select count(*) from 100000-row table, check \timing with and without explain analyze)? If we could get a clearer picture of which platforms show the problem and which don't, maybe we could make some progress. (BTW, I just tried it on my Apple Powerbook G4, and got results in line with what I get elsewhere. So I've now tried it on three very different CPU types and OSes, and not duplicated Simon's problem on any of them.) regards, tom lane
В списке pgsql-hackers по дате отправления: