Re: [PERFORM] Best way to load test a postgresql server

Technically you can then use pgbench on that set of statements, but I usually just use perl's "Benchmark" module (i'm sure ruby or java or whatever has a similar tool) (First, I log statements by loading the application or web server with statement logging turned on so I'm not "guessing" w

Re: [PERFORM] Best way to load test a postgresql server

Shaul Dar writes: > Have you actually run pgbench against your own schema? Can you point me to > an example? I also had the same impression reading the documentation. But > when I tried it with the proper flags to use my own DB and query file I got > an error that it couldn't find one of the table

Re: [PERFORM] Best way to load test a postgresql server

On Thu, Jun 4, 2009 at 2:01 AM, Greg Smith wrote: > > If you want to load test your own specific DB then I am unaware of any >> such tools. >> > > pgbench will run against any schema and queries, the built-in set are just > the easiest to use. I just released a bunch of slides and a package I n

Re: [PERFORM] Best way to load test a postgresql server

On Tue, 2 Jun 2009, Shaul Dar wrote: If you want to test the H/W and configuration of your DBMS then you can use the pgbench tool (which uses a specific built-in DB+schema, following the TPC benchmark). There are a lot of TPC benchmarks. pgbench simulates TPC-B (badly), which is a benchmark

Re: [PERFORM] Best way to load test a postgresql server

On Wed, 03 Jun 2009 05:29:02 -0400, Dimitri Fontaine wrote: Last time I used it it was in the context of a web application and to compare PostgreSQL against Informix after a migration. So I used the HTTP protocol support of the injector. Tsung seems well suited for that. Tsung is based on e

Re: [PERFORM] Best way to load test a postgresql server

I considered Tsung myself but haven't tried it. If you intend to, I suggest you read this excellent tutorial on using Tsung for test-loading Postgresql. While impressed I decided the procedure was too daunting and went with JMeter :-)

Re: [PERFORM] Best way to load test a postgresql server

"Kenneth Cox" writes: > On Tue, 02 Jun 2009 05:26:41 -0400, Dimitri Fontaine > wrote: >> I'd recommand having a look at tsung which will be able to replay a >> typical application scenario with as many concurrent users as you want >> to: http://archives.postgresql.org/pgsql-admin/2008-12/msg00032

Re: [PERFORM] Best way to load test a postgresql server

Hi Peter, I was looking for the same recently, and my answer is as follows: 1. If you want to test the *H/W and configuration of your DBMS* then you can use the pgbench tool (which uses a specific built-in DB+schema, following the TPC benchmark). 2. If you want to *load test your own specific DB

Re: [PERFORM] Best way to load test a postgresql server

On Tue, 02 Jun 2009 05:26:41 -0400, Dimitri Fontaine wrote: I'd recommand having a look at tsung which will be able to replay a typical application scenario with as many concurrent users as you want to: http://archives.postgresql.org/pgsql-admin/2008-12/msg00032.php http://tsung.erlang-pr

Re: [PERFORM] Best way to load test a postgresql server

Hi, "Peter Sheats" writes: > I’m about to set up a large instance on Amazon EC2 to be our DB server. > > Before we switch to using it in production I would like to simulate some load on it so that I know what it can handle and so that I can make sure I have the > optimal settings in the conf

Re: [PERFORM] Best way to load test a postgresql server

Disclaimer : I'm very much a newbie here! But I am on the path in my new job to figure this stuff out as well, and went to PG Con here in Ottawa 2 weeks ago and attended quite a few lectures on this topic. Have a look at : http://wiki.postgresql.org/wiki/PgCon_2009 And in particular "Database H

[PERFORM] Best way to load test a postgresql server

Hi, I¹m about to set up a large instance on Amazon EC2 to be our DB server. Before we switch to using it in production I would like to simulate some load on it so that I know what it can handle and so that I can make sure I have the optimal settings in the config file. What is the best strategy