[postgis-users] pgbench

[José María]

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130117/b07318ec/attachment.html>