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 по дате отправления:

Предыдущее
От: Rajesh Kumar Mallah
Дата:
Сообщение: Re: Suggestions for benchmarking 7.4RC2 against 7.3
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: *very* slow query to summarize data for a month ...