Re: Having no luck with getting pgbench to run multipletimes

From: Justin Clift <justin(at)postgresql(dot)org>
To: Greg Copeland <greg(at)CopelandConsulting(dot)Net>
Cc: PostgreSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Having no luck with getting pgbench to run multipletimes
Date: 2002-09-20 15:52:18
Message-ID: 3D8B4432.FB5B04CD@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Mike Mascari 2002-09-20 15:54:52 Re: Win32 rename()/unlink() questions
Previous Message Shridhar Daithankar 2002-09-20 15:52:08 Improving speed of copy