[postgis-users] pgbench

[Donovan Cameron]

I checked, and it looks like it is part of the postgresql-contrib
package for your system (Ubuntu 10.04 - Lucid).
You can verify that in the list of programs/functions that come with
that package at
http://packages.ubuntu.com/lucid/postgresql-contrib-8.4

In case your wondering, on those pages I've linked too, if you have to
get in touch with the package maintainers for more info, their emails
are below the "Maintainer: " portion on the right tab/menu of the
page.

On Mon, Jan 21, 2013 at 3:32 PM, Donovan Cameron <sault.don at gmail.com> wrote:
> Hey José,
>
> The details on the postgresql-contrib packages are here:
> http://packages.ubuntu.com/lucid/database/postgresql-contrib
>
> You should be able to install it on Ubuntu 10.04 with: apt-get install
> postgresql-contrib
>
> After that is installed, open a terminal and type: pgbench --version
>
> That should output: pgbench (PostgreSQL) 9.1.x
>
> If it throws an error, chances are it's not in the postgresql-contrib
> package and you will have better luck getting in touch with the
> package maintainers and submitting an "enhancement" request so that
> pgbench is included in postgresql-contrib.
>
> On Thu, Jan 17, 2013 at 1:14 AM, José María <jmamuedo at gmail.com> wrote:
>> Thanks Donovan!!
>>
>> I got information about alloptions of pgbench, but I didn found information
>> about how can install this tool.
>>
>> I have installed postgresql9.1 and postgis 2.0 in a ubuntu 10.04 linux
>> machine.
>>
>> But the question is that I don't know how can install pgbench. I did "locate
>> contrib" and this was the result:
>>
>> /usr/share/doc/postgresql-contrib-9.1
>> /usr/share/doc/postgresql-contrib-9.1/autoinc.example
>> /usr/share/doc/postgresql-contrib-9.1/changelog.Debian.gz
>> /usr/share/doc/postgresql-contrib-9.1/copyright
>> /usr/share/doc/postgresql-contrib-9.1/insert_username.example
>> /usr/share/doc/postgresql-contrib-9.1/moddatetime.example
>> /usr/share/doc/postgresql-contrib-9.1/refint.example
>> /usr/share/doc/postgresql-contrib-9.1/timetravel.example
>> /var/cache/apt/archives/postgresql-contrib-9.1_9.1.7-0ubuntu12.04_i386.deb
>> /var/lib/dpkg/info/postgresql-contrib-9.1.list
>> /var/lib/dpkg/info/postgresql-contrib-9.1.md5sums
>> /var/lib/dpkg/info/postgresql-contrib-9.1.postinst
>> /var/lib/dpkg/info/postgresql-contrib-9.1.prerm
>>
>> Donovan, Could you help me with this? What do I have to do?
>>
>> Thanks!!
>>
>> José María
>>
>>
>>
>> 2013/1/16 Donovan Cameron <sault.don at gmail.com>
>>>
>>> Hey Jose,
>>>
>>> At least on linux, it's part of the postgresql-contrib package and can
>>> be accessed via CLI.
>>>
>>> Usage:
>>>   pgbench [OPTIONS]... [DBNAME]
>>>
>>> Initialization options:
>>>   -i           invokes initialization mode
>>>   -F NUM       fill factor
>>>   -s NUM       scaling factor
>>>
>>> Benchmarking options:
>>>   -c NUM       number of concurrent database clients (default: 1)
>>>   -C           establish new connection for each transaction
>>>   -D VARNAME=VALUE
>>>                define variable for use by custom script
>>>   -f FILENAME  read transaction script from FILENAME
>>>   -j NUM       number of threads (default: 1)
>>>   -l           write transaction times to log file
>>>   -M {simple|extended|prepared}
>>>                protocol for submitting queries to server (default: simple)
>>>   -n           do not run VACUUM before tests
>>>   -N           do not update tables "pgbench_tellers" and
>>> "pgbench_branches"
>>>   -r           report average latency per command
>>>   -s NUM       report this scale factor in output
>>>   -S           perform SELECT-only transactions
>>>   -t NUM       number of transactions each client runs (default: 10)
>>>   -T NUM       duration of benchmark test in seconds
>>>   -v           vacuum all four standard tables before tests
>>>
>>> Common options:
>>>   -d           print debugging output
>>>   -h HOSTNAME  database server host or socket directory
>>>   -p PORT      database server port number
>>>   -U USERNAME  connect as specified database user
>>>   --help       show this help, then exit
>>>   --version    output version information, then exit
>>>
>>> Report bugs to <pgsql-bugs at postgresql.org>
>>>
>>> If you let the mailing list know what operating system your using for
>>> postgresql then you'll probably get a better answer.
>>>
>>>
>>>
>>> Donovan
>>>
>>> On Wed, Jan 16, 2013 at 8:23 AM, José María <jmamuedo at gmail.com> wrote:
>>> > Help!!
>>> >
>>> > I need use pgbench but I don't know how to install and use this tool!!
>>> >
>>> > Any idea?
>>> >
>>> > Thanks
>>> >
>>> > _______________________________________________
>>> > postgis-users mailing list
>>> > postgis-users at lists.osgeo.org
>>> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>> >
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at lists.osgeo.org
>>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>