[postgis-users] pgbench

[Donovan Cameron]

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
>