Re: Suggestions for benchmarking 7.4RC2 against 7.3
От | Rajesh Kumar Mallah |
---|---|
Тема | Re: Suggestions for benchmarking 7.4RC2 against 7.3 |
Дата | |
Msg-id | 3FB2A540.2000808@trade-india.com обсуждение исходный текст |
Ответ на | Re: Suggestions for benchmarking 7.4RC2 against 7.3 (Christopher Browne <cbbrowne@acm.org>) |
Список | pgsql-performance |
<br /><br /> RC2 is running in production without any apparent problems<br /> till now. Well its difficult to say at themoment how much speed<br /> gain is there unless the heavy duty batch SQL scripts are run by<br /> cron. <br /><br />Count(*) and group by on large tables are significantly (5x) faster<br /> and better error reporting has made it easierto spot the faulty data.<br /> eg in fkey violation.<br /><br /> Will post the OSDB .15 versions' results on 7.3 &7.4 soon.<br /><br /> Regds<br /> Mallah.<br /><br /> Christopher Browne wrote:<br /><blockquote cite="midm34qxau6bb.fsf@wolfe.cbbrowne.com"type="cite"><pre wrap="">After a long battle with technology,<a class="moz-txt-link-abbreviated"href="mailto:mallah@trade-india.com">mallah@trade-india.com</a> (Rajesh Kumar Mallah), anearthling, wrote: </pre><blockquote type="cite"><pre wrap="">the error mentioned in first email has been overcome by running osdb on the same machine hosting the DB server. </pre></blockquote><pre wrap=""> Yes, it seems unrealistic to try to run the "client" on a separate host from the database. I got the osdb benchmark running last week, and had to separate client from server. I had to jump through a fair number of hoops including copying data files over to the server. The benchmark software needs a bit more work... </pre></blockquote><br />
В списке pgsql-performance по дате отправления: