Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2011
    Posts
    3

    Unanswered: Performance assessment

    I am working a java project for user administration (online game). I use postgres on my localhost (latest version), latest jdbc driver (1.4). My system has the following config: intel i3 350m @2.26Ghz and 8gb ddr3 and windows 7 professional.

    The problem is that I can only average 428 operations per second when I run tests on my java project (i run multiple threads). For each "operation" i have 2 inserts, one update and one simple select query. Is this a good performance? What can I espect from postgres on my system.

    My customer complains about the low number of operations per second and fears application lag.
    Last edited by stefan_vasco; 03-18-11 at 05:35.

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by stefan_vasco View Post
    latest jdbc driver (1.4).
    Whatever version you are referring to: 1.4 is definitely not "current"

  3. #3
    Join Date
    Mar 2011
    Posts
    3
    my mistake Download i use: JDBC4 Postgresql Driver, Version 9.0-801

  4. #4
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by stefan_vasco View Post
    The problem is that I can only average 428 operations per second when I run tests on my java project (i run multiple threads). For each "operation" i have 2 inserts, one update and one simple select query. Is this a good performance? What can I espect from postgres on my system.
    With this workload you are most probably constrained by IO (I'm pretty sure the people on the Postgres mailing list could even calculate your max. IO if you give them the specs of your hardware).

    You did not provide the most important information for a database server: What kind of harddisk system is that server using?
    A RAID 10 with at least 4 disks is (as far as I'm concerned) the minimum for a decent database server. The more disks you have the faster your server will be.
    Additionally the Windows file system is not known for good speed, especially for database servers.

    One thing you could try to speed up write performance is to turn off synchronous commits if you can afford that in case of a system failure (e.g. power outage) some transactions are lost.

    Another thing to look at is checkpoint_segments. With that workload you should defintely increase them. The default number is way to low for that. For your system start with 32 or even 64. Larger system even go up to 256.

    Make sure you read:
    Performance Optimization - PostgreSQL wiki
    Tuning Your PostgreSQL Server - PostgreSQL wiki

    You might also want to grab a copy of this book:
    https://www.packtpub.com/postgresql-...rformance/book

  5. #5
    Join Date
    Mar 2011
    Posts
    3
    Thank you!

Tags for this Thread

Posting Permissions

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