Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2010
    Posts
    11

    Unanswered: PostgreSQL 9.3 throughput and response time

    Hi

    Are there some (official) statistics about throughput and response time available for the postgreSQL 9.3 database?

    Thanks for the help.

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    No, there are no official statistics because you cannot come up with something like that.

    It depends on too many variables: type of cpu, number of cpus, type of hard disk, number of hard disks, type of disk controller, number of disk controllers, main memory, cache memory on the disk controllers, network card, number of network cards, the operating system, the file system, the configuration of the operating system (e.g. the scheduler), the configuration of the file system and so on.

    And finally it also depends heavily on your data, on your data model and the queries you run on that data.

    Postgres comes with its own TPC benchmark program that you can use to test what your hardware can deliver: http://www.postgresql.org/docs/curre...c/pgbench.html
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

  3. #3
    Join Date
    Feb 2010
    Posts
    11
    Thank you very much.

    The TPC-benchmark program from Postgres seems to be very good and easy, I will read a tutorial how to use it.

    As I've read the throughput will be measured with transactions per second. Is there also a possibility to measure the response time with pgbench?

    By the way, I have a schema with only 3 tables and I want to benchmark only one table, i.e. I want to have insert, deletes and reads of rows in that table. How would you do this with pgbench?
    Last edited by Helveticus; 11-02-14 at 12:11.

  4. #4
    Join Date
    Feb 2010
    Posts
    11
    Would be very nice if somebody can help.

    Should I execute pgbench on the same machine as the database is running or remotely?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •