X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id CB8949DC9E1 for ; Fri, 10 Mar 2006 05:59:40 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 26915-07 for ; Fri, 10 Mar 2006 05:59:42 -0400 (AST) X-Greylist: delayed 00:09:21.142465 by SQLgrey- Received: from michael.eatserver.nl (michael.eatserver.nl [212.203.14.103]) by postgresql.org (Postfix) with ESMTP id B0D589DC99A for ; Fri, 10 Mar 2006 05:59:37 -0400 (AST) Received: from dvipc (82-170-251-187.dsl.ip.tiscali.nl [82.170.251.187]) (authenticated bits=0) by michael.eatserver.nl (8.12.10/8.12.10/SuSE Linux 0.7) with ESMTP id k2A9xcNd005644 for ; Fri, 10 Mar 2006 10:59:39 +0100 From: "H.J. Sanders" To: Subject: FW: x206-x226 Date: Fri, 10 Mar 2006 10:59:46 +0100 Message-ID: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_000D_01C64431.BE7B5D80" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.097 required=5 tests=[AWL=0.096, HTML_MESSAGE=0.001] X-Spam-Score: 0.097 X-Spam-Level: X-Archive-Number: 200603/113 X-Sequence-Number: 17550 This is a multi-part message in MIME format. ------=_NextPart_000_000D_01C64431.BE7B5D80 Content-Type: multipart/alternative; boundary="----=_NextPart_001_000E_01C64431.BE7B5D80" ------=_NextPart_001_000E_01C64431.BE7B5D80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hello list. Reading my own e-mail I notice I made a very important mistake. The X206 has 1 x ATA 7200 RPM The X226 has 2 x SCSI RAID1 10000RPM I corrected it below. Sorry . Henk Sanders -----Oorspronkelijk bericht----- Van: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org]Namens H.J. Sanders Verzonden: vrijdag 10 maart 2006 10:50 Aan: pgsql-performance@postgresql.org Onderwerp: [PERFORM] x206-x225 Hello list. We have compared 2 IBM x servers: IBM X206 IBM X226 ---------------------- ------------------- processor Pentium 4 3.2 Ghz Xeon 3.0 Ghz main memory 1.25 GB 4 GB discs 1 x ATA 7200 RPM 2 x SCSI RAID1 10000RPM LINUX 2.6 (SUSE 9) same PGSQL 7.4 same postgresql.conf attached same We have bij means of an informix-4GL program done the following test: create table : name char(18) adres char(20) key integer create index on (key) Ti me at X206 Time at X226 -------------- ------ ------------------ insert record (key goes from 1 to 10000) 6 sec. 41 sec. select record (key goes from 1 to 10000) 4 4 delete record (key goes from 1 to 10000) 6 41 This is ofcourse a totally unexpected results (you should think off the opposite). Funny is that the select time is the same for both machines. Does anybody has any any idea what can cause this strange results or where we can start our investigations? Regards Henk Sanders ------=_NextPart_001_000E_01C64431.BE7B5D80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello = list.
 
Reading my=20 own e-mail I notice I made a very important = mistake.
 
The=20 X206  has  1 x ATA 7200 RPM
The X226=20 has  2 x SCSI=20 RAID1  10000RPM    
 
I corrected=20 it below.
 
Sorry=20 .
 
 
Henk=20 Sanders
 
       &nbs= p; =20
 -----Oorspronkelijk=20 bericht-----
Van: pgsql-performance-owner@postgresql.org=20 [mailto:pgsql-performance-owner@postgresql.org]Namens H.J.=20 Sanders
Verzonden: vrijdag 10 maart 2006 10:50
Aan:=20 pgsql-performance@postgresql.org
Onderwerp: [PERFORM]=20 x206-x225

Hello=20 list.
 
We have compared = 2 IBM x=20 servers:
 
       &nbs= p;            = ;           =20 IBM=20 = X206           &nb= sp;           &nbs= p;            = ;  =20 IBM X226
          &nbs= p;            = ;            = =20 = ----------------------        &nb= sp;           &nbs= p;      =20 -------------------
processor         &= nbsp;           &n= bsp; =20 Pentium 4 3.2=20 = Ghz           &nbs= p;            = ;   =20 Xeon 3.0 Ghz   
main=20 = memory           &= nbsp;       =20 1.25=20 = GB            = ;            =             &= nbsp;  =20 4 GB       
discs          = ;            =         =20 1 x ATA 7200 RPM       &nbs= p;            = ;   =20  2 x SCSI=20 = RAID1  10000RPM        =      =20
 
LINUX          = ;            =      =20 2.6 (SUSE=20 = 9)            = ;            =            =20 same
PGSQL          = ;            =      =20 = 7.4           &nbs= p;            = ;            =             &= nbsp; same
postgresql.conf        &= nbsp;     =20 = attached           = ;            =             &= nbsp;       =20 same
 
 
We have bij means = of an=20 informix-4GL program done the following test:
 
 
create = table  : name=20 char(18)
       &nbs= p;       =20 adres char(20)
       &nbs= p;       =20 key    integer
 
create index on=20 (key)
          &nbs= p;            = ;            =             &= nbsp;           &n= bsp;           =20 Time at = X206           =20 Time at X226
       &nbs= p;            = ;            =             &= nbsp;           &n= bsp;  =20 --------------------       =20 ------------------
 
insert record = (key goes from=20 1 to=20 = 10000)           &= nbsp;=20 6=20 = sec.           &nb= sp;           =20 41 sec.
select record = (key goes from=20 1 to = 10000)            = = 4            =             &= nbsp;       =20 4
delete record = (key goes from=20 1 to = 10000)            = = 6            =             &= nbsp;      =20 41
 
 
This is ofcourse = a totally=20 unexpected results (you should think off the = opposite).
 
Funny is that the = select time=20 is the same for both machines.
 
Does anybody has = any any idea=20 what can cause this strange results or where we
can start our=20 investigations?
 
 
Regards
 
 
Henk=20 Sanders
 
 
 
 
 

------=_NextPart_001_000E_01C64431.BE7B5D80-- ------=_NextPart_000_000D_01C64431.BE7B5D80 Content-Type: application/octet-stream; name="postgresql.conf-74" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="postgresql.conf-74" # -----------------------------=0A= # PostgreSQL configuration file=0A= # -----------------------------=0A= #=0A= # This file consists of lines of the form:=0A= #=0A= # name =3D value=0A= #=0A= # (The '=3D' is optional.) White space may be used. Comments are = introduced=0A= # with '#' anywhere on a line. The complete list of option names and=0A= # allowed values can be found in the PostgreSQL documentation. The=0A= # commented-out settings shown in this file represent the default values.=0A= #=0A= # Any option can also be given as a command line switch to the=0A= # postmaster, e.g. 'postmaster -c log_connections=3Don'. Some options=0A= # can be changed at run-time with the 'SET' SQL command.=0A= #=0A= # This file is read on postmaster startup and when the postmaster=0A= # receives a SIGHUP. If you edit the file on a running system, you have =0A= # to SIGHUP the postmaster for the changes to take effect, or use =0A= # "pg_ctl reload".=0A= =0A= =0A= #------------------------------------------------------------------------= ---=0A= # CONNECTIONS AND AUTHENTICATION=0A= #------------------------------------------------------------------------= ---=0A= =0A= # - Connection Settings -=0A= =0A= #tcpip_socket =3D false=0A= max_connections =3D 100=0A= # note: increasing max_connections costs about 500 bytes of shared=0A= # memory per connection slot, in addition to costs from shared_buffers=0A= # and max_locks_per_transaction.=0A= #superuser_reserved_connections =3D 2=0A= #port =3D 5432=0A= #unix_socket_directory =3D ''=0A= #unix_socket_group =3D ''=0A= #unix_socket_permissions =3D 0777 # octal=0A= #virtual_host =3D '' # what interface to listen on; defaults to any=0A= #rendezvous_name =3D '' # defaults to the computer name=0A= =0A= # - Security & Authentication -=0A= =0A= #authentication_timeout =3D 60 # 1-600, in seconds=0A= #ssl =3D false=0A= #password_encryption =3D true=0A= #krb_server_keyfile =3D ''=0A= #db_user_namespace =3D false=0A= =0A= =0A= #------------------------------------------------------------------------= ---=0A= # RESOURCE USAGE (except WAL)=0A= #------------------------------------------------------------------------= ---=0A= =0A= # - Memory -=0A= =0A= #dvi=0A= shared_buffers =3D 12000 # min 16, at least max_connections*2, 8KB each=0A= sort_mem =3D 10240 # min 64, size in KB was 1024=0A= #vacuum_mem =3D 8192 # min 1024, size in KB=0A= =0A= # - Free Space Map -=0A= =0A= #max_fsm_pages =3D 20000 # min max_fsm_relations*16, 6 bytes each=0A= #max_fsm_relations =3D 1000 # min 100, ~50 bytes each=0A= max_fsm_relations =3D 500 # min 100, ~50 bytes each=0A= =0A= # - Kernel Resource Usage -=0A= =0A= #max_files_per_process =3D 1000 # min 25=0A= #preload_libraries =3D ''=0A= =0A= =0A= #------------------------------------------------------------------------= ---=0A= # WRITE AHEAD LOG=0A= #------------------------------------------------------------------------= ---=0A= =0A= # - Settings -=0A= =0A= #fsync =3D true # turns forced synchronization on or off=0A= #wal_sync_method =3D fsync # the default varies across platforms:=0A= # fsync, fdatasync, open_sync, or open_datasync=0A= #wal_buffers =3D 8 # min 4, 8KB each=0A= wal_buffers =3D 64 # min 4, 8KB each=0A= =0A= # - Checkpoints -=0A= =0A= #dvi checkpoint_segments =3D 3 # in logfile segments, min 1, 16MB each=0A= checkpoint_segments =3D 30 # in logfile segments, min 1, 16MB each=0A= =0A= #checkpoint_timeout =3D 300 # range 30-3600, in seconds=0A= #checkpoint_warning =3D 30 # 0 is off, in seconds=0A= #commit_delay =3D 0 # range 0-100000, in microseconds=0A= #commit_siblings =3D 5 # range 1-1000=0A= =0A= =0A= #------------------------------------------------------------------------= ---=0A= # QUERY TUNING=0A= #------------------------------------------------------------------------= ---=0A= =0A= # - Planner Method Enabling -=0A= =0A= #enable_hashagg =3D true=0A= #enable_hashjoin =3D true=0A= #enable_indexscan =3D true=0A= #enable_mergejoin =3D true=0A= #enable_nestloop =3D true=0A= #enable_seqscan =3D true=0A= #enable_sort =3D true=0A= #enable_tidscan =3D true=0A= =0A= # - Planner Cost Constants -=0A= =0A= #effective_cache_size =3D 1000 # typically 8KB each=0A= #random_page_cost =3D 4 # units are one sequential page fetch cost=0A= #cpu_tuple_cost =3D 0.01 # (same)=0A= #cpu_index_tuple_cost =3D 0.001 # (same)=0A= #cpu_operator_cost =3D 0.0025 # (same)=0A= =0A= # - Genetic Query Optimizer -=0A= =0A= #geqo =3D true=0A= geqo =3D false=0A= #geqo_threshold =3D 11=0A= #geqo_effort =3D 1=0A= #geqo_generations =3D 0=0A= #geqo_pool_size =3D 0 # default based on tables in statement,=0A= # range 128-1024=0A= #geqo_selection_bias =3D 2.0 # range 1.5-2.0=0A= =0A= # - Other Planner Options -=0A= =0A= #default_statistics_target =3D 10 # range 1-1000=0A= #from_collapse_limit =3D 8=0A= #join_collapse_limit =3D 8 # 1 disables collapsing of explicit JOINs=0A= =0A= =0A= #------------------------------------------------------------------------= ---=0A= # ERROR REPORTING AND LOGGING=0A= #------------------------------------------------------------------------= ---=0A= =0A= # - Syslog -=0A= =0A= #syslog =3D 0 # range 0-2; 0=3Dstdout; 1=3Dboth; 2=3Dsyslog=0A= #syslog_facility =3D 'LOCAL0'=0A= #syslog_ident =3D 'postgres'=0A= =0A= # - When to Log -=0A= =0A= #client_min_messages =3D notice # Values, in order of decreasing detail:=0A= # debug5, debug4, debug3, debug2, debug1,=0A= # log, info, notice, warning, error=0A= =0A= #log_min_messages =3D notice # Values, in order of decreasing detail:=0A= # debug5, debug4, debug3, debug2, debug1,=0A= # info, notice, warning, error, log, fatal,=0A= # panic=0A= =0A= #log_error_verbosity =3D default # terse, default, or verbose messages=0A= =0A= #log_min_error_statement =3D panic # Values in order of increasing = severity:=0A= # debug5, debug4, debug3, debug2, debug1,=0A= # info, notice, warning, error, panic(off)=0A= =0A= #log_min_duration_statement =3D -1 # Log all statements whose=0A= # execution time exceeds the value, in=0A= # milliseconds. Zero prints all queries.=0A= # Minus-one disables.=0A= =0A= #silent_mode =3D false # DO NOT USE without Syslog!=0A= =0A= # - What to Log -=0A= =0A= #debug_print_parse =3D false=0A= #debug_print_rewritten =3D false=0A= #debug_print_plan =3D false=0A= #debug_pretty_print =3D false=0A= #log_connections =3D false=0A= #log_duration =3D false=0A= #log_pid =3D false=0A= #log_statement =3D false=0A= log_timestamp =3D true=0A= #log_hostname =3D false=0A= #log_source_port =3D false=0A= #dvi=0A= log_statement =3D true=0A= #debug_print_plan =3D true=0A= #log_duration =3D true=0A= log_min_duration_statement =3D 2000=0A= =0A= #------------------------------------------------------------------------= ---=0A= # RUNTIME STATISTICS=0A= #------------------------------------------------------------------------= ---=0A= =0A= # - Statistics Monitoring -=0A= =0A= #log_parser_stats =3D false=0A= #log_planner_stats =3D false=0A= #log_executor_stats =3D false=0A= #log_statement_stats =3D false=0A= =0A= # - Query/Index Statistics Collector -=0A= =0A= #stats_start_collector =3D true=0A= #stats_command_string =3D false=0A= #stats_block_level =3D false=0A= #stats_row_level =3D false=0A= #stats_reset_on_server_start =3D true=0A= =0A= =0A= #dvi=0A= stats_start_collector =3D true=0A= stats_command_string =3D true=0A= stats_block_level =3D true=0A= stats_row_level =3D true=0A= #------------------------------------------------------------------------= ---=0A= # CLIENT CONNECTION DEFAULTS=0A= #------------------------------------------------------------------------= ---=0A= =0A= # - Statement Behavior -=0A= =0A= #search_path =3D '$user,public' # schema names=0A= #check_function_bodies =3D true=0A= #default_transaction_isolation =3D 'read committed'=0A= #default_transaction_read_only =3D false=0A= #statement_timeout =3D 0 # 0 is disabled, in milliseconds=0A= =0A= # - Locale and Formatting -=0A= =0A= datestyle =3D 'european'=0A= #datestyle =3D 'iso, mdy'=0A= #timezone =3D unknown # actually, defaults to TZ environment setting=0A= #australian_timezones =3D false=0A= #extra_float_digits =3D 0 # min -15, max 2=0A= #client_encoding =3D sql_ascii # actually, defaults to database encoding=0A= =0A= # These settings are initialized by initdb -- they may be changed=0A= lc_messages =3D 'en_US.UTF-8' # locale for system error message strings=0A= lc_monetary =3D 'en_US.UTF-8' # locale for monetary formatting=0A= lc_numeric =3D 'en_US.UTF-8' # locale for number formatting=0A= lc_time =3D 'en_US.UTF-8' # locale for time formatting=0A= =0A= # - Other Defaults -=0A= =0A= #explain_pretty_print =3D true=0A= #dynamic_library_path =3D '$libdir'=0A= #max_expr_depth =3D 10000 # min 10=0A= =0A= =0A= #------------------------------------------------------------------------= ---=0A= # LOCK MANAGEMENT=0A= #------------------------------------------------------------------------= ---=0A= =0A= #deadlock_timeout =3D 1000 # in milliseconds=0A= #max_locks_per_transaction =3D 64 # min 10, ~260*max_connections bytes = each=0A= =0A= =0A= #------------------------------------------------------------------------= ---=0A= # VERSION/PLATFORM COMPATIBILITY=0A= #------------------------------------------------------------------------= ---=0A= =0A= # - Previous Postgres Versions -=0A= =0A= #add_missing_from =3D true=0A= #regex_flavor =3D advanced # advanced, extended, or basic=0A= #sql_inheritance =3D true=0A= =0A= # - Other Platforms & Clients -=0A= =0A= #transform_null_equals =3D false=0A= ------=_NextPart_000_000D_01C64431.BE7B5D80 Content-Type: text/plain; name="ATT00011.txt" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="ATT00011.txt" ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly ------=_NextPart_000_000D_01C64431.BE7B5D80--