As I see only Windows7 supported ( with EnterpriseDB version of PostgreSQL 9.2 Windows installer ) http://www.enterprisedb.com/products-services-training/products-overview/postgresql-overview/supported-platforms-and-release-lif
Have you been tested with PostgreSQL 9.3 rc1 ? same speed ? http://www.enterprisedb.com/products-services-training/pgdevdownload and some testing tips: - modify laptop power settings - compare disk speeds (laptop vs. desktop ) - ... Imre 2013/8/22 girish subbaramu <gsubbar...@hotmail.com> > > Hi, > > I am running PostgreSQL 9.2.4 on windows 8 , 64 bit operating system , > 4GB RAM. > A laptop with i3 - 3110M , 2.4 GHZ . > The database came bundled with wapp stack 5.4.17-0. We have an php > application that serves data from PostgreSQL 9.2.4. > > The configuration runs with very good performance (3 sec response php + db > ) on windows 7 32, 64 bit OS , 4GB RAM (desktops with i3-2100 3.10 GHZ ) . > But take around 25 seconds to render on windows 8 , the laptop. > > I was able to eliminate php , as the performance was as expected. (without > DB calls) > On the other part the database calls take more than 100 ms for simple > queries (Example a table with just 10 row sometimes takes around 126 ms). > This information i was able to collect from the pg_log. > > The php pages have multiple queries in them, a single query works as > expected, but running multiple queries in the page causes the db > performance to go down. Please note this setup is working fine (3 sec > overall including php ) on all windows 7 32, 64 bit OS , desktops. > > Appreciate help in giving me an direction on how to get to the issue. > The db size is 11mb only. Most of the tables have less than 100 rows with > appropriate indexes. Some tables have more than 1000 rows , are not queried > in the php pages . The super user login is used from php . (Changing super > user reserved connections did not help, tried changing shared _buffers and > other setting , none of the setting seem to have any effect on the db > performance ) > > Following are the variable settings that works fine on on all windows 7 > 32, 64 bit OS , desktops. > > > > Name Settingallow_system_table_modsoffapplication_name archive_command > (disabled)archive_modeoff archive_timeout0array_nullson > authentication_timeout1minautovacuumonautovacuum_analyze_scale_factor 0.1 > autovacuum_analyze_threshold50autovacuum_freeze_max_age 200000000 > autovacuum_max_workers3autovacuum_naptime 1minautovacuum_vacuum_cost_delay > 20msautovacuum_vacuum_cost_limit -1autovacuum_vacuum_scale_factor0.2 > autovacuum_vacuum_threshold 50backslash_quotesafe_encodingbgwriter_delay200ms > bgwriter_lru_maxpages100bgwriter_lru_multiplier 2block_size8192bonjouroff > bonjour_namebytea_outputescapecheck_function_bodies on > checkpoint_completion_target0.5checkpoint_segments 3checkpoint_timeout5min > checkpoint_warning30s client_encodingUTF8client_min_messagesnotice > commit_delay0commit_siblings5 config_file > C:/xxxx~2/POSTGR~1/data/postgresql.confconstraint_exclusionpartition > cpu_index_tuple_cost0.005cpu_operator_cost0.0025 cpu_tuple_cost0.01 > cursor_tuple_fraction0.1data_directory C:/xxx~2/POSTGR~1/dataDateStyleISO, > MDYdb_user_namespace offdeadlock_timeout1sdebug_assertionsoff > debug_pretty_printondebug_print_parseoff debug_print_planoff > debug_print_rewrittenoff default_statistics_target100default_tablespace > default_text_search_config pg_catalog.english > default_transaction_deferrableoffdefault_transaction_isolation read > committeddefault_transaction_read_onlyoffdefault_with_oids off > dynamic_library_path$libdireffective_cache_size 128MB > effective_io_concurrency0enable_bitmapscan onenable_hashaggon > enable_hashjoinon enable_indexonlyscanonenable_indexscanon enable_material > onenable_mergejoinonenable_nestloop onenable_seqscanonenable_sorton > enable_tidscanonescape_string_warningonevent_source PostgreSQL > exit_on_erroroffexternal_pid_file extra_float_digits0from_collapse_limit8 > fsynconfull_page_writeson geqoongeqo_effort5geqo_generations 0 > geqo_pool_size0geqo_seed0 geqo_selection_bias2geqo_threshold12 > gin_fuzzy_search_limit 0hba_fileC:/xxxx~2/POSTGR~1/data/pg_hba.conf > hot_standby offhot_standby_feedbackoffident_file > C:/xxxx~2/POSTGR~1/data/pg_ident.conf ignore_system_indexesoff > integer_datetimeson IntervalStylepostgresjoin_collapse_limit8 > krb_caseins_usersoffkrb_server_keyfilekrb_srvname > postgreslc_collateEnglish_United > States.1252lc_ctype English_United States.1252lc_messagesEnglish_United > States.1252 lc_monetaryEnglish_United States.1252lc_numericEnglish_United > States.1252 lc_timeEnglish_United States.1252listen_addresses127.0.0.1 > lo_compat_privilegesofflocal_preload_libraries log_autovacuum_min_duration > -1log_checkpointsoff log_connectionsofflog_destinationstderrlog_directory > pg_loglog_disconnectionsofflog_durationoff log_error_verbositydefault > log_executor_statsoff log_file_mode0600log_filename > postgresql-%Y-%m-%d_%H%M%S.log log_hostnameofflog_line_prefix > log_lock_waitsofflog_min_duration_statement-1 log_min_error_statementerror > log_min_messageswarning log_parser_statsofflog_planner_statsoff > log_rotation_age 1dlog_rotation_size10MBlog_statementnone > log_statement_statsofflog_temp_files-1 log_timezoneAsia/Calcutta > log_truncate_on_rotationoff > logging_collectoronmaintenance_work_mem16MBmax_connections > 100max_files_per_process1000max_function_args 100max_identifier_length63 > max_index_keys32 max_locks_per_transaction64max_pred_locks_per_transaction > 64max_prepared_transactions0max_stack_depth 2MBmax_standby_archive_delay > 30smax_standby_streaming_delay 30smax_wal_senders0password_encryptionon > port5432post_auth_delay0 pre_auth_delay0quote_all_identifiersoff > random_page_cost 4replication_timeout1minrestart_after_crash onsearch_path > "$user",viplsegment_size 1GBseq_page_cost1server_encodingUTF8 > server_version9.2.4server_version_num90204session_replication_role origin > shared_buffers1GBshared_preload_libraries sql_inheritanceonssloff > ssl_ca_filessl_cert_fileserver.crtssl_ciphers > ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTHssl_crl_filessl_key_file server.key > ssl_renegotiation_limit512MBstandard_conforming_strings on > statement_timeout0stats_temp_directorypg_stat_tmp > superuser_reserved_connections3synchronize_seqscanson synchronous_commiton > synchronous_standby_names syslog_facilitynonesyslog_identpostgres > tcp_keepalives_count0tcp_keepalives_idle-1tcp_keepalives_interval -1 > temp_buffers16MBtemp_file_limit-1 temp_tablespacesTimeZoneAsia/Calcutta > timezone_abbreviationsDefaulttrace_notifyoff trace_recovery_messageslog > trace_sortofftrack_activities ontrack_activity_query_size1024track_countson > track_functionsnonetrack_io_timingoff transaction_deferrableoff > transaction_isolationread committed transaction_read_onlyoff > transform_null_equalsoff unix_socket_directoryunix_socket_group > unix_socket_permissions0777update_process_titleon vacuum_cost_delay0 > vacuum_cost_limit200vacuum_cost_page_dirty 20vacuum_cost_page_hit1 > vacuum_cost_page_miss 10vacuum_defer_cleanup_age0vacuum_freeze_min_age50000000 > vacuum_freeze_table_age150000000wal_block_size 8192wal_buffers16MB > wal_keep_segments0 wal_levelminimalwal_receiver_status_interval10s > wal_segment_size16MBwal_sync_methodopen_datasync wal_writer_delay200ms > work_mem512MB xmlbinarybase64xmloptioncontentzero_damaged_pages off > > > > > Thanks > Girish Subbaramu. > >
