Re: INDEX Performance Issue

Поиск
Список
Период
Сортировка
От Mark Davidson
Тема Re: INDEX Performance Issue
Дата
Msg-id CAPpwVW1hfK+LazBuW-wUE2-sqOOqE_pW_1WO7Xu72vD=QxzK0w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: INDEX Performance Issue  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-performance
Дерево обсуждения
Hi Jeff,

I'ved tried this test using the -S flag './pgbench -c 4 -j 2 -T 600 -S pgbench'

Desktop gives me

./pgbench -c 4 -j 2 -T 600 -S pgbench
starting vacuum...end.
transaction type: SELECT only
scaling factor: 1
query mode: simple
number of clients: 4
number of threads: 2
duration: 600 s
number of transactions actually processed: 35261835
tps = 58769.715695 (including connections establishing)
tps = 58770.258977 (excluding connections establishing)

Server

./pgbench -c 4 -j 2 -T 600 -S pgbench
starting vacuum...end.
transaction type: SELECT only
scaling factor: 1
query mode: simple
number of clients: 4
number of threads: 2
duration: 600 s
number of transactions actually processed: 22642303
tps = 37737.157641 (including connections establishing)
tps = 37738.167325 (excluding connections establishing)



On 8 April 2013 21:39, Jeff Janes <jeff.janes@gmail.com> wrote:
On Mon, Apr 8, 2013 at 12:31 PM, Mark Davidson <mark@4each.co.uk> wrote:
Thanks for your response Vasillis. I've run pgbench on both machines `./pgbench -c 10 -t 10000 pgbench` getting 99.800650 tps on my local machine and 23.825332 tps on the server so quite a significant difference.

These results are almost certainly being driven by how fast your machines can fsync the WAL data.  The type of query you originally posted does not care about that at all, so these results are not useful to you.  You could run the "pgbench -S", which is getting closer to the nature of the work your original query does (but still not all that close).  

Cheers,

Jeff

В списке pgsql-performance по дате отправления:

Предыдущее
От: Mark Davidson
Дата:
Сообщение: Re: INDEX Performance Issue
Следующее
От: Dave Johansen
Дата:
Сообщение: Re: Picking out the most recent row using a time stamp column