Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VDr9K-0005Lw-Ea for pgsql-performance@arkaria.postgresql.org; Mon, 26 Aug 2013 07:23:42 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VDr9J-00027v-TX for pgsql-performance@arkaria.postgresql.org; Mon, 26 Aug 2013 07:23:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VDr9I-00027o-Cw for pgsql-performance@postgresql.org; Mon, 26 Aug 2013 07:23:40 +0000 Received: from bay0-omc3-s6.bay0.hotmail.com ([65.54.190.144]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VDr9D-0004KO-Ce for pgsql-performance@postgresql.org; Mon, 26 Aug 2013 07:23:40 +0000 Received: from BAY175-W28 ([65.54.190.187]) by bay0-omc3-s6.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.4675); Mon, 26 Aug 2013 00:23:32 -0700 X-TMN: [oZ/7kTKy372j6kx2cCE+e4cupQ/zPu8P] X-Originating-Email: [gsubbaramu@hotmail.com] Message-ID: Content-Type: multipart/alternative; boundary="_eee38f2f-3b4f-435a-b6c5-0b5f7a7d5214_" From: girish subbaramu To: Imre Samu CC: "pgsql-performance@postgresql.org" Subject: Re: PostgreSQL 9.2.4 very slow on laptop with windows 8 Date: Mon, 26 Aug 2013 07:23:32 +0000 Importance: Normal In-Reply-To: References: , MIME-Version: 1.0 X-OriginalArrivalTime: 26 Aug 2013 07:23:32.0873 (UTC) FILETIME=[2B94E790:01CEA22D] X-Pg-Spam-Score: -3.0 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org --_eee38f2f-3b4f-435a-b6c5-0b5f7a7d5214_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi =2C Thanks for the inputs and direction.With the help of the support table i na= rrowed down to windows 2008 and 2003 servers.32 bit postgres 9.2.4 was very= slow on windows 2008 (64 bit )=2C on running postgres 9.2.4 64 bit the re= sponse time was similar to what i used to get on windows 7. I did not have = to do any performance tuning =2C the defaults worked.This works good for me= .With this i was able to resolve postgres issues.=20 ThanksGirish Subbaramu=20 From: pella.samu@gmail.com Date: Thu=2C 22 Aug 2013 17:25:51 +0200 Subject: Re: [PERFORM] PostgreSQL 9.2.4 very slow on laptop with windows 8 To: gsubbaramu@hotmail.com CC: pgsql-performance@postgresql.org As I see only Windows7 supported ( with EnterpriseDB version of PostgreSQL= 9.2 Windows installer )http://www.enterprisedb.com/products-services-train= ing/products-overview/postgresql-overview/supported-platforms-and-release-l= if=0A= =0A= Have you been tested with PostgreSQL 9.3 rc1 ? same speed ?http://www.e= nterprisedb.com/products-services-training/pgdevdownload=0A= =0A= and some testing tips: - modify laptop power settings - compare disk speeds (laptop vs. desktop ) - ... Imre 2013/8/22 girish subbaramu =0A= =0A= =0A= =0A= =0A= Hi=2C I am running PostgreSQL 9.2.4 on windows 8 =2C 64 bit operating system =2C= 4GB RAM.=0A= =0A= A laptop with i3 - 3110M =2C 2.4 GHZ . The database came bundled with wapp= stack 5.4.17-0. We have an php application that serves data from PostgreSQ= L 9.2.4.=0A= =0A= The configuration runs with very good performance (3 sec response php + db = ) on windows 7 32=2C 64 bit OS =2C 4GB RAM (desktops with i3-2100 3.10 GH= Z ) .=0A= =0A= But take around 25 seconds to render on windows 8 =2C the laptop.=20 I was able to eliminate php =2C as the performance was as expected. (withou= t DB calls)On the other part the database calls take more than 100 ms for s= imple queries (Example a table with just 10 row sometimes takes around 126 = ms). This information i was able to collect from the pg_log.=0A= =0A= The php pages have multiple queries in them=2C a single query works as expe= cted=2C but running multiple queries in the page causes the db performance = to go down. Please note this setup is working fine (3 sec overall includin= g php ) on all windows 7 32=2C 64 bit OS =2C desktops.=0A= =0A= 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 appropr= iate indexes. Some tables have more than 1000 rows =2C are not queried in = the php pages . The super user login is used from php . (Changing super use= r reserved connections did not help=2C tried changing shared _buffers and o= ther setting =2C none of the setting seem to have any effect on the db perf= ormance )=0A= =0A= Following are the variable settings that works fine on on all windows 7 = 32=2C 64 bit OS =2C desktops.=20 =0A= =0A= Name=0A= =0A= Settingallow_system_table_modsoffapplication_name=0A= =0A= archive_command(disabled)archive_modeoff=0A= =0A= archive_timeout0array_nullson=0A= =0A= authentication_timeout1minautovacuumonautovacuum_analyze_scale_factor=0A= =0A= 0.1autovacuum_analyze_threshold50autovacuum_freeze_max_age=0A= =0A= 200000000autovacuum_max_workers3autovacuum_naptime=0A= =0A= 1minautovacuum_vacuum_cost_delay20msautovacuum_vacuum_cost_limit=0A= =0A= -1autovacuum_vacuum_scale_factor0.2autovacuum_vacuum_threshold=0A= =0A= 50backslash_quotesafe_encodingbgwriter_delay=0A= =0A= 200msbgwriter_lru_maxpages100bgwriter_lru_multiplier=0A= =0A= 2block_size8192bonjouroff=0A= =0A= bonjour_namebytea_outputescapecheck_function_bodies=0A= =0A= oncheckpoint_completion_target0.5checkpoint_segments=0A= =0A= 3checkpoint_timeout5mincheckpoint_warning30s=0A= =0A= client_encodingUTF8client_min_messagesnotice=0A= =0A= commit_delay0commit_siblings5=0A= =0A= config_fileC:/xxxx~2/POSTGR~1/data/postgresql.confconstraint_exclusionparti= tion=0A= =0A= cpu_index_tuple_cost0.005cpu_operator_cost0.0025=0A= =0A= cpu_tuple_cost0.01cursor_tuple_fraction0.1=0A= data_directory=0A= C:/xxx~2/POSTGR~1/dataDateStyleISO=2C MDYdb_user_namespace=0A= =0A= offdeadlock_timeout1sdebug_assertionsoff=0A= =0A= debug_pretty_printondebug_print_parseoff=0A= =0A= debug_print_planoffdebug_print_rewrittenoff=0A= =0A= default_statistics_target100default_tablespace=0A= default_text_search_config=0A= pg_catalog.englishdefault_transaction_deferrableoff=0A= default_transaction_isolation=0A= read committeddefault_transaction_read_onlyoffdefault_with_oids=0A= =0A= offdynamic_library_path$libdireffective_cache_size=0A= =0A= 128MBeffective_io_concurrency0enable_bitmapscan=0A= =0A= onenable_hashaggonenable_hashjoinon=0A= =0A= enable_indexonlyscanonenable_indexscanon=0A= =0A= enable_materialonenable_mergejoinonenable_nestloop=0A= =0A= onenable_seqscanonenable_sorton=0A= =0A= enable_tidscanonescape_string_warningonevent_source=0A= =0A= PostgreSQLexit_on_erroroffexternal_pid_file=0A= =0A= extra_float_digits0from_collapse_limit8=0A= =0A= fsynconfull_page_writeson=0A= =0A= geqoongeqo_effort5geqo_generations=0A= =0A= 0geqo_pool_size0geqo_seed0=0A= =0A= geqo_selection_bias2geqo_threshold12gin_fuzzy_search_limit=0A= =0A= 0hba_fileC:/xxxx~2/POSTGR~1/data/pg_hba.confhot_standby=0A= =0A= offhot_standby_feedbackoffident_fileC:/xxxx~2/POSTGR~1/data/pg_ident.conf= =0A= =0A= ignore_system_indexesoffinteger_datetimeson=0A= =0A= IntervalStylepostgresjoin_collapse_limit8=0A= =0A= krb_caseins_usersoffkrb_server_keyfilekrb_srvname=0A= =0A= postgreslc_collateEnglish_United States.1252lc_ctype=0A= =0A= English_United States.1252lc_messagesEnglish_United States.1252=0A= =0A= lc_monetaryEnglish_United States.1252lc_numericEnglish_United States.1252= =0A= =0A= lc_timeEnglish_United States.1252listen_addresses127.0.0.1=0A= =0A= lo_compat_privilegesofflocal_preload_libraries=0A= =0A= log_autovacuum_min_duration-1log_checkpointsoff=0A= =0A= log_connectionsofflog_destinationstderrlog_directory=0A= =0A= pg_loglog_disconnectionsofflog_durationoff=0A= =0A= log_error_verbositydefaultlog_executor_statsoff=0A= =0A= log_file_mode0600log_filenamepostgresql-%Y-%m-%d_%H%M%S.log=0A= =0A= log_hostnameofflog_line_prefix=0A= =0A= log_lock_waitsofflog_min_duration_statement-1=0A= =0A= log_min_error_statementerrorlog_min_messageswarning=0A= =0A= log_parser_statsofflog_planner_statsofflog_rotation_age=0A= =0A= 1dlog_rotation_size10MBlog_statementnone=0A= =0A= log_statement_statsofflog_temp_files-1=0A= =0A= log_timezoneAsia/Calcuttalog_truncate_on_rotationoff=0A= =0A= logging_collectoronmaintenance_work_mem16MB=0A= =0A= max_connections100max_files_per_process1000max_function_args=0A= =0A= 100max_identifier_length63max_index_keys32=0A= =0A= max_locks_per_transaction64max_pred_locks_per_transaction=0A= =0A= 64max_prepared_transactions0max_stack_depth=0A= =0A= 2MBmax_standby_archive_delay30smax_standby_streaming_delay=0A= =0A= 30smax_wal_senders0password_encryptionon=0A= =0A= port5432post_auth_delay0=0A= =0A= pre_auth_delay0quote_all_identifiersoffrandom_page_cost=0A= =0A= 4replication_timeout1minrestart_after_crash=0A= =0A= onsearch_path"$user"=2Cviplsegment_size=0A= =0A= 1GBseq_page_cost1server_encodingUTF8=0A= =0A= server_version9.2.4server_version_num90204=0A= session_replication_role=0A= originshared_buffers1GBshared_preload_libraries=0A= =0A= sql_inheritanceonssloff=0A= =0A= ssl_ca_filessl_cert_fileserver.crtssl_ciphers=0A= =0A= ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTHssl_crl_filessl_key_file=0A= =0A= server.keyssl_renegotiation_limit512MBstandard_conforming_strings=0A= =0A= onstatement_timeout0stats_temp_directorypg_stat_tmp=0A= =0A= superuser_reserved_connections3synchronize_seqscans=0A= on=0A= synchronous_commitonsynchronous_standby_names=0A= =0A= syslog_facilitynonesyslog_identpostgres=0A= =0A= tcp_keepalives_count0tcp_keepalives_idle-1=0A= tcp_keepalives_interval=0A= -1temp_buffers16MBtemp_file_limit-1=0A= =0A= temp_tablespacesTimeZoneAsia/Calcutta=0A= =0A= timezone_abbreviationsDefaulttrace_notifyoff=0A= =0A= trace_recovery_messageslogtrace_sortofftrack_activities=0A= =0A= ontrack_activity_query_size1024track_counts=0A= =0A= ontrack_functionsnonetrack_io_timingoff=0A= =0A= transaction_deferrableofftransaction_isolationread committed=0A= =0A= transaction_read_onlyofftransform_null_equalsoff=0A= =0A= unix_socket_directoryunix_socket_group=0A= =0A= unix_socket_permissions0777update_process_titleon=0A= =0A= vacuum_cost_delay0vacuum_cost_limit200vacuum_cost_page_dirty=0A= =0A= 20vacuum_cost_page_hit1vacuum_cost_page_miss=0A= =0A= 10vacuum_defer_cleanup_age0vacuum_freeze_min_age=0A= =0A= 50000000vacuum_freeze_table_age150000000wal_block_size=0A= =0A= 8192wal_buffers16MBwal_keep_segments0=0A= =0A= wal_levelminimalwal_receiver_status_interval10s=0A= =0A= wal_segment_size16MBwal_sync_methodopen_datasync=0A= =0A= wal_writer_delay200mswork_mem512MB=0A= =0A= xmlbinarybase64xmloptioncontentzero_damaged_pages=0A= =0A= off ThanksGirish Subbaramu. =0A= =0A= =0A= = --_eee38f2f-3b4f-435a-b6c5-0b5f7a7d5214_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi =2C

Thanks= for the inputs and direction.
With the help of the support table= i narrowed down to windows 2008 and 2003 servers.
32 bit postgre= s 9.2.4 was very slow on windows 2008 (64 bit )=2C on running postgres 9.2.= 4 64 bit  =3Bthe response time was similar to what i used to get on win= dows 7. I did not have to do any performance tuning =2C the defaults worked= .
This works good for me.With = this i was able to resolve postgres issues. =3B

Thanks
Girish Subbaramu


From: pella.samu@gmail.com
Date: Thu=2C 22 Aug 2013 17= :25:51 +0200
Subject: Re: [PERFORM] PostgreSQL 9.2.4 very slow on laptop= with windows 8
To: gsubbaramu@hotmail.com
CC: pgsql-performance@post= gresql.org

As I see only Windows7 supported &n= bsp=3B( with EnterpriseDB version of PostgreSQL 9.2 Windows installer )
http://www.enterprisedb.com/products-services-training/prod= ucts-overview/postgresql-overview/supported-platforms-and-release-lif=0A= =0A=

Have you been tested with PostgreSQL 9.3 rc1 ?  =3B=  =3B same speed ?
=0A= =0A=

and some testing tips:
- modify laptop power settings
- comp= are disk speeds (laptop vs. desktop )
- ...

Imre


2013/8/22 gi= rish subbaramu <=3Bgsubbaramu@hotmail.com>=3B
=0A= =0A=
=0A= =0A= =0A=

Hi=2C

I am running =3BPostgreSQL 9.2.4 =3Bon windows 8  =3B=2C 64 bit= operating system =2C 4GB RAM.
=0A= =0A=
A laptop with i3 - 3110M =2C 2.4 GHZ . =3B
The database =  =3Bcame bundled with wapp stack =3B5.4.17-0. We have an php applic= ation that serves data from =3BPostgreSQL 9.2.4.
=0A= =0A=

The configuration runs with ver= y good performance (3 sec response php + db ) on windows 7  =3B 32=2C 6= 4 bit OS =2C 4GB RAM (desktops with i3-2100 3.10 GHZ ) .
=0A= =0A=
But take around 25 seconds to render on windows 8 =2C the laptop. = =3B

I was able to eliminate php =2C as the perform= ance was as expected. (without DB calls)
On the other part the da= tabase calls take more than 100 ms for simple queries (Example a table with= just 10 row sometimes takes around 126 ms).  =3BThis information i was= able to collect from the pg_log.
=0A= =0A=

The php pages have multiple queries in them=2C a single= query works as expected=2C but running multiple queries in the page causes= the db performance to go down. Please note this setup is working fine (3 s= ec  =3Boverall including php ) on all =3B =3Bwindows 7  =3B= 32=2C 64 bit OS =2C desktops.
=0A= =0A=

Appreciate hel= p in giving me an direction on how to get to the issue.
The db si= ze is 11mb only. Most of the tables have less than 100 rows with appropriat= e indexes. Some tables have more than 1000 rows =2C are not queried  = =3Bin the php pages . The super user login is used from php . (Changing sup= er user reserved connections did not help=2C tried changing shared _buffers= and other setting =2C none of the setting seem to have any effect on the d= b performance )
=0A= =0A=

Following are the variable settings that works fine on&= nbsp=3B =3Bon all =3B =3Bwindows 7  =3B 32=2C 64 bit OS =2C= desktops. =3B

=0A=
=0A=
 =3B
=0A= =0A= = = = =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= autovacuum_vacuum_cost_limit=0A= =0A= autovacuum_vacuum_threshold=0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= = =0A= =0A= = =0A= =0A= constraint_exclusion=0A= =0A= <= td>0.0025=0A= =0A= =0A= = =0A= =0A= =0A= =0A= <= td>off=0A= =0A= off<= td>=0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= = =0A= =0A= =0A= =0A= = =0A= =0A= =0A= =0A= =0A= =0A= = = =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= = 8=0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= off=0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= = warning=0A= =0A= =0A= =0A= =0A= =0A= -1=0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= <= td>UTF8=0A= = =0A= =0A= =0A= =0A= =0A= =0A= = =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= = =0A= =0A= -1=0A= =0A= =0A= = =0A= =0A= off=0A= =0A= =0A= =0A= = =0A= =0A= =0A= =0A= = =0A= =0A= =0A= =0A= =0A= =0A= wal_block_size=0A= =0A= =0A= =0A= = =0A= =0A= = =0A= =0A= = = =0A= =0A= =0A= =0A=
Name=0A= =0A= Setting
allow_system_table_modsoff
appli= cation_name=0A= =0A=
archive_command(disabled)
archive_mode<= /td>off
archive_timeout0
array_nullson
authentication_timeout1min
autovacuumon<= /td>
autovacuum_analyze_scale_factor0.1
autovacuum_analyze_threshold50
a= utovacuum_freeze_max_age200000000
autovacuum_max_workers3
= autovacuum_naptime1min
autovacuum_vacuum_cost_delay20ms
-1
autovacuum_vacuum_scale_factor0.2
50
backslash_quotesafe_encoding
bgwr= iter_delay=0A= =0A= 200ms
bgwriter_lru_maxpages100
bgwriter_= lru_multiplier2
block_size8192
bonjouroff=
bonjour_name
bytea_outputescape
check_function_bodieson
checkpoint_completion_target0.5
c= heckpoint_segments3
checkpoint_timeout5min
checkpoint_= warning30s
client_encodingUTF8
client_min_messagesnotice
commit_delay0
commit_siblings5
config_fileC:/xxxx~2/POSTGR~1/data/postgresql.conf
partition
cpu_index_tuple_cost0.005
cpu_operator_cost
cpu_tuple_cost0.01
cursor_tuple_fraction= 0.1
=0A= data_directoryC:/xxx~2/POSTGR~1/data
DateStyleISO=2C MDY
db_user_namespaceoff
deadlock_timeout1s
debug_asserti= onsoff
debug_pretty_printon
debug_print_parse
debug_print_planoff
debug_print_rewritten
=0A= =0A= default_statistics_target100
default_tablespace
=0A= default_text_search_configpg_catalog.english
default_transaction_deferrable= off
=0A= default_transaction_isolationread committed
default_transaction_read_onlyoff
default_with_oidsoff
dynamic_library_path$libdir
effe= ctive_cache_size128MB
effective_io_concurrency0
enab= le_bitmapscanon
enable_hashaggon
enable_hashjoin<= /td>on
enable_indexonlyscanon
enable_indexscano= n
enable_materialon
enable_mergejoinon
enable_nestloopon
enable_seqscanon
enable_sorton
enable_tidscanon
escape_string_warningon=
event_sourcePostgreSQL
exit_on_erroroff
exter= nal_pid_file=0A= =0A=
extra_float_digits0
from_collapse_limit= 8
fsyncon
full_page_writeson
geqoon
geqo_effort5
geqo_= generations=0A= =0A= 0
geqo_pool_size0
geqo_seed0
geqo_selection_bias2
geqo_threshold12
gin_fuzzy_search_limit0
hba_fileC:/xxxx~2/POSTGR~1/data/pg_hba.conf
hot_standbyoff
hot_standby_feedbackoff
ident_fi= leC:/xxxx~2/POSTGR~1/data/pg_ident.conf
ignore_system_indexesoff
integer_datetimeson
IntervalStylepostgres
join_collapse_limit
krb_caseins_usersoff
krb_server_keyfile<= /td>
krb_srvnamepostgres
lc_collateEnglish_United States.1252
lc_ctypeEnglish_United States.1252
lc_messagesEnglish_Uni= ted States.1252
lc_monetaryEnglish_United States.1252
lc_numeric<= /td>English_United States.1252
lc_timeEnglish_United States.1252
listen_addresse= s127.0.0.1
lo_compat_privilegesoff
local_preload_libraries
=0A= log_autovacuum_min_duration-1
log_checkpoints
=0A= =0A= log_connectionsoff
log_destinationstderr
log_directorypg_log
log_disconnectionsoff
log_d= urationoff
log_error_verbositydefault
log_executor_stat= soff
log_file_mode0600
log_filenamepostg= resql-%Y-%m-%d_%H%M%S.log
log_hostnameoff
log_line_prefix
log_lock_waitsoff
log_min_duration_statement-1
=0A= =0A= log_min_error_statementerror
log_min_messages
log_parser_statsoff
log_planner_statsoff=
log_rotation_age1d
log_rotation_size10MB
log_stateme= ntnone
log_statement_statsoff
log_temp_files
log_timezoneAsia/Calcutta
log_truncate_on_rotatio= noff
logging_collectoron
maintenance_work_mem= 16MB
=0A= =0A= max_connections100
max_files_per_process100= 0
max_function_args100
max_identifier_length63
max_inde= x_keys32
max_locks_per_transaction64
max_pred_locks_p= er_transaction64
max_prepared_transactions0
max_s= tack_depth=0A= =0A= 2MB
max_standby_archive_delay30s
max_s= tandby_streaming_delay30s
max_wal_senders0
password_encryp= tionon
port5432
post_auth_delay0
pre_auth_delay0
quote_all_identifiersoff=
random_page_cost4
replication_timeout1min
restart_af= ter_crash=0A= =0A= on
search_path"$user"=2Cvipl
segment_siz= e=0A= =0A= 1GB
seq_page_cost1
server_encoding
server_version9.2.4
server_version_num90= 204
=0A= session_replication_roleorigin
shared_buffers1GB
shared_prel= oad_libraries
sql_inheritanceon
ssloff
ssl_ca_file
ssl_cert_fileserver.crt
ssl_ciphersALL:!ADH:!LOW:!EXP:!MD5:@STRENGTH
ssl_crl_file
ssl_key_fileserver.key
ssl_renegotiation_limit512MB
standard_conforming_stringson
statement_timeout0
stats_temp_dir= ectorypg_stat_tmp
superuser_reserved_connections3
synchronize_= seqscans=0A= on
synchronous_commiton
synchronous_standby_nam= es
syslog_facilitynone
syslog_identpostgres=
tcp_keepalives_count0
tcp_keepalives_idle
=0A= tcp_keepalives_interval-1
temp_buffers16MB
temp_file_limit<= /td>-1
temp_tablespaces
TimeZoneAsia/Calcutta
timezone_abbreviationsDefault
trace_notify
=0A= =0A= trace_recovery_messageslog
trace_sortoff
track_activitieson
track_activity_query_size1024
tra= ck_counts=0A= =0A= on
track_functionsnone
track_io_timingoff
transaction_deferrableoff
transaction_isolationread committed
transaction_read_onlyoff
transform_null_equa= lsoff
unix_socket_directory
unix_socket_group
unix_socket_permissions0777
update_process_title<= /td>on
vacuum_cost_delay0
vacuum_cost_limit200<= /td>
vacuum_cost_page_dirty20
vacuum_cost_page_hit1
vacuum_cost= _page_miss=0A= =0A= 10
vacuum_defer_cleanup_age0
vacuum_free= ze_min_age=0A= =0A= 50000000
vacuum_freeze_table_age150000000
8192
wal_buffers16MB
wal_keep_segmen= ts0
wal_levelminimal
wal_receiver_status_interval10s
wal_segment_size16MB
wal_sync_methodopen= _datasync
wal_writer_delay200ms
work_mem512MB
xmlbinarybase64
xmloptioncontent
zero_damaged_pagesoff




Thanks
Girish Subbaramu.

=0A= =0A=
=0A=

= --_eee38f2f-3b4f-435a-b6c5-0b5f7a7d5214_--