Re: TESTING the DATABASE

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Himmet Karaman <karamanhi(at)itu(dot)edu(dot)tr>
Cc: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: TESTING the DATABASE
Date: 2003-05-15 14:45:16
Message-ID: Pine.LNX.4.33.0305150841500.2429-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

If you want to test your own schema to make sure it works (i.e. foreign
key relations work right, etc...) You'll have to write your own SQL to
prove it.

If you want to test your postgresql installation to make sure it's stable
and reliable under load, there are several different benchmarks out there
that can help.

pgbench comes with postgresql, and is in the $SRC/contrib/pgbench
directory. Just cd there as root and do a 'make install' to install it,
then run it as a normal postgresql user to see it's options.

Look for the OSDB test suite on google, it's much larger and more
stressing on the system than pgbench tends to be, and is meant to be a
more well rounded benchmarking suite.

Finally, there's a nearly finished TPC-C style benchmark on sourceforge:

http://sourceforge.net/cvs/?group_id=52479

which was reported here on the list a few days ago. No idea how close to
finished it is, but it's probably worth a look.

On Thu, 15 May 2003, Himmet Karaman wrote:

> Hi,
> I want to test all part of the database.
> If the relations work, and all of the tables are ok, and can i make
> queries on my database...
> i mean can my database do everything wright?
> Is there any tool or command to test it?
> Thanks again
>
> Nigel J. Andrews wrote:
>
> >On Thu, 15 May 2003, Himmet Karaman wrote:
> >
> >
> >
> >>Hello to all,
> >>Is there anyone who can explain me briefly, how can I test the database
> >>that I created using PostgreSQL?
> >>Thanks a lot for the time you spent ...
> >>
> >>
> >
> >
> >Well, at a basic level...
> >
> >$ psql mydbname
> >Welcome to psql 7.3.2, the PostgreSQL interactive terminal.
> >
> >Type: \copyright for distribution terms
> > \h for help with SQL commands
> > \? for help on internal slash commands
> > \g or terminate with semicolon to execute query
> > \q to quit
> >
> >mydbname=> create table mytable ( a integer );
> >mydbname=> insert into mytable (a) values (1);
> >mydbname=> select * from mytable;
> > a
> >---
> > 1
> >(1 row)
> >
> >mydbname=>\q
> >
> >
> >The question is, what is it you want to test?
> >
> >
> >
> >
>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2003-05-15 14:59:40 Re: pg_proc.prosrc -> can I see the function's source?
Previous Message Raquel Vieira 2003-05-15 13:47:41 Re: Postgresql suddenly shutdown. Please help

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-05-15 14:47:53 Re: psql and bytea
Previous Message Henrik Steffen 2003-05-15 13:14:59 Re: sub-select