Re: Having no luck with getting pgbench to run multipletimes

Поиск
Список
Период
Сортировка
От Justin Clift
Тема Re: Having no luck with getting pgbench to run multipletimes
Дата
Msg-id 3D8B4432.FB5B04CD@postgresql.org
обсуждение исходный текст
Ответ на Having no luck with getting pgbench to run multiple times  (Justin Clift <justin@postgresql.org>)
Список pgsql-hackers
Hi Greg,

That's cool.  Played with it for a while longer, then found out that the
order that it was being called in didn't work very well as the select()
was executed after all the required sockets had been closed/ended.

So, it just meant a re-ordering of things, and it's now working alright.

Am just "fine tuning" this util, and it's looking to be pretty nifty. 
It automatically tunes local or remote PostgreSQL databases (currently
it's limited to the shared_buffers, sort_mem, and vacuum_mem
variables).  But it's a start.  :)

Regards and best wishes,

Justin Clift


Greg Copeland wrote:
> 
> Well, you'll probably want to pass in a valid timeval structure if you
> don't want it to block.
> 
> Basically, that snippet tells select on the list of sockets, looking for
> sockets that have data to be read while waiting forever.  That means it
> will block until something appears on one of the sockets your
> monitoring.
> 
> Greg


-- 
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."  - Indira Gandhi


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Win32 rename()/unlink() questionst
Следующее
От: Mike Mascari
Дата:
Сообщение: Re: Win32 rename()/unlink() questions