Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2014
    Posts
    5

    Unanswered: Performance issues with PostgreSQL 9.3 on windows OS

    We are working on migrating the database from SQL Aaywhare to Postgres. We're doing performance-testing built on Java and PostgreSQL On windows with 8 GB RAM. When we are testing with 10K Transactions Postgres taking 10ms and where as SQL Anywhare is taking 3ms.

    Another interesting point is that the CPU utilization only up to a max of 70% to 80% when we are running Transactions in Postgres.

    We wanted to bring down the Postgres execution time for 10K Transactions equivalent to SQL Anywhare. like around 3 to 4 ms.

    Here are the settings:

    shared_buffers = 1GB
    log_min_duration_statement = 100
    maintenance_work_mem=64MB
    wal_buffers =MB
    work_mem=16MB
    max_prepared_transactions =25
    temp_buffers=8MB
    effective_cache_size=1024MB
    checkpoint_segments = 00
    cpu_tuple_cost = 0.0030
    cpu_index_tuple_cost = 0.0010
    cpu_operator_cost = 0.0005
    fsync = off
    checkpoint_timeout = 45mins
    autovacuum_analyze_threshold =20k
    synchronous_commit =on
    full_page_writes =ooff

    Help on this will be really appreciated. We are stuck on this for about a 15 days .now and have tried various permutations and combinations.

  2. #2
    Join Date
    Dec 2014
    Posts
    5

    Postgres performance Tunning

    We are working on migrating the database from SQL Aaywhare to Postgres. We're doing performance-testing built on Java and PostgreSQL On windows with 8 GB RAM. When we are testing with 10K Transactions Posgres taking 10ms and where as SQL Anywhare is taking 3ms.

    Another interesting point is that the CPU utilization only up to a max of 70% to 80% when we are running Transactions in Postgres.


    Here are the settings:

    shared_buffers = 1GB
    log_min_duration_statement = 100
    maintenance_work_mem=64MB
    wal_buffers =MB
    work_mem=16MB
    max_prepared_transactions =25
    temp_buffers=8MB
    effective_cache_size=1024MB
    checkpoint_segments = 00
    cpu_tuple_cost = 0.0030
    cpu_index_tuple_cost = 0.0010
    cpu_operator_cost = 0.0005
    fsync = off
    checkpoint_timeout = 45mins
    autovacuum_analyze_threshold =20k
    synchronous_commit =on
    full_page_writes =ooff

    Help on this will be really appreciated. We are stuck on this for about a week now and have tried various permutations and combinations.

  3. #3
    Join Date
    Dec 2014
    Posts
    5

    Postgresperformance in Window OS with 8GB RAM

    We are working on migrating the database from SQL Aaywhare to Postgres. We're doing performance-testing built on Java and PostgreSQL On windows with 8 GB RAM. When we are testing with 10K Transactions Posgres taking 10ms and where as SQL Anywhare is taking 3ms.

    Another interesting point is that the CPU utilization only up to a max of 70% to 80% when we are running Transactions in Postgres.


    Here are the settings:

    shared_buffers = 1GB
    log_min_duration_statement = 100
    maintenance_work_mem=64MB
    wal_buffers =MB
    work_mem=16MB
    max_prepared_transactions =25
    temp_buffers=8MB
    effective_cache_size=1024MB
    checkpoint_segments = 00
    cpu_tuple_cost = 0.0030
    cpu_index_tuple_cost = 0.0010
    cpu_operator_cost = 0.0005
    fsync = off
    checkpoint_timeout = 45mins
    autovacuum_analyze_threshold =20k
    synchronous_commit =on
    full_page_writes =ooff

    Help on this will be really appreciated. We are stuck on this for about a week now and have tried various permutations and combinations.

  4. #4
    Join Date
    Dec 2014
    Posts
    5

    Postgres performance issue

    We are working on migrating the database from SQL Aaywhare to Postgres. We're doing performance-testing built on Java and PostgreSQL On windows with 8 GB RAM. When we are testing with 10K Transactions Posgres taking 10ms and where as SQL Anywhare is taking 3ms.

    Another interesting point is that the CPU utilization only up to a max of 70% to 80% when we are running Transactions in Postgres.


    Here are the settings:

    shared_buffers = 1GB
    log_min_duration_statement = 100
    maintenance_work_mem=64MB
    wal_buffers =MB
    work_mem=16MB
    max_prepared_transactions =25
    temp_buffers=8MB
    effective_cache_size=1024MB
    checkpoint_segments = 00
    cpu_tuple_cost = 0.0030
    cpu_index_tuple_cost = 0.0010
    cpu_operator_cost = 0.0005
    fsync = off
    checkpoint_timeout = 45mins
    autovacuum_analyze_threshold =20k
    synchronous_commit =on
    full_page_writes =ooff

    Help on this will be really appreciated. We are stuck on this for about a week now and have tried various permutations and combinations.

Posting Permissions

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