http://forum.postgresql.org.pl/index.php Wed, 08 Sep 2010 10:59:12 +0000 PunBB http://forum.postgresql.org.pl/viewtopic.php?id=485&action=new Wed, 08 Sep 2010 10:59:12 +0000 http://forum.postgresql.org.pl/viewtopic.php?id=485&action=new http://forum.postgresql.org.pl/viewtopic.php?id=484&action=new Sun, 05 Sep 2010 08:05:29 +0000 http://forum.postgresql.org.pl/viewtopic.php?id=484&action=new http://forum.postgresql.org.pl/viewtopic.php?id=483&action=new Tue, 31 Aug 2010 18:19:19 +0000 http://forum.postgresql.org.pl/viewtopic.php?id=483&action=new http://forum.postgresql.org.pl/viewtopic.php?id=476&action=new 0 logs only # statements running at least this time. #silent_mode = off # DO NOT USE without syslog or # logging_collector # (change requires restart) # - What to Log - #debug_print_parse = off #debug_print_rewritten = off #debug_print_plan = off #debug_pretty_print = off #log_checkpoints = off #log_connections = off #log_disconnections = off #log_duration = off #log_hostname = off log_line_prefix = '%t ' # special values: # %u = user name # %d = database name # %r = remote host and port # %h = remote host # %p = process ID # %t = timestamp without milliseconds # %m = timestamp with milliseconds # %i = command tag # %c = session ID # %l = session line number # %s = session start timestamp #log_lock_waits = off # log lock waits >= deadlock_timeout #log_statement = 'none' # none, ddl, mod, all #log_temp_files = -1 # log temporary files equal or larger # than specified size; # -1 disables, 0 logs all temp files #log_timezone = unknown # actually, defaults to TZ environment # setting #------------------------------------------------------------------------------ # RUNTIME STATISTICS #------------------------------------------------------------------------------ # - Query/Index Statistics Collector - #track_activities = on #track_counts = on #update_process_title = on # - Statistics Monitoring - #log_parser_stats = off #log_planner_stats = off #log_executor_stats = off #log_statement_stats = off #------------------------------------------------------------------------------ # AUTOVACUUM PARAMETERS #------------------------------------------------------------------------------ autovacuum = on # Enable autovacuum subprocess? 'on' # requires track_counts to also be on. log_autovacuum_min_duration = -1 # -1 disables, 0 logs all actions and # their durations, > 0 logs only # actions running at least that time. autovacuum_max_workers = 3 # max number of autovacuum subprocesses #autovacuum_naptime = 1min # time between autovacuum runs #autovacuum_vacuum_threshold = 50 # min number of row updates before # vacuum #autovacuum_analyze_threshold = 50 # min number of row updates before # analyze #autovacuum_vacuum_scale_factor = 0.2 # fraction of table size before vacuum #autovacuum_analyze_scale_factor = 0.1 # fraction of table size before analyze #autovacuum_freeze_max_age = 200000000 # maximum XID age before forced vacuum # (change requires restart) #autovacuum_vacuum_cost_delay = 20 # default vacuum cost delay for #autovacuum_vacuum_cost_limit = -1 # default vacuum cost limit for # autovacuum, -1 means use # vacuum_cost_limit #------------------------------------------------------------------------------ # CLIENT CONNECTION DEFAULTS #------------------------------------------------------------------------------ # - Statement Behavior - #search_path = '"$user",public' # schema names #default_tablespace = '' # a tablespace name, '' uses the default #temp_tablespaces = '' # a list of tablespace names, '' uses # only default tablespace #check_function_bodies = on #default_transaction_isolation = 'read committed' #default_transaction_read_only = off #session_replication_role = 'origin' #statement_timeout = 0 # 0 is disabled #vacuum_freeze_min_age = 100000000 #xmlbinary = 'base64' #xmloption = 'content' # - Locale and Formatting - datestyle = 'iso, mdy' #timezone = unknown # actually, defaults to TZ environment # setting #timezone_abbreviations = 'Default' # Select the set of available time zone # abbreviations. Currently, there are # Default # Australia # India #extra_float_digits = 0 # min -15, max 2 #client_encoding = sql_ascii # actually, defaults to database # encoding # These settings are initialized by initdb, but they can be changed. lc_messages = 'pl_PL.UTF-8' # locale for system error message # strings lc_monetary = 'pl_PL.UTF-8' # locale for monetary formatting lc_numeric = 'pl_PL.UTF-8' # locale for number formatting lc_time = 'pl_PL.UTF-8' # default configuration for text search default_text_search_config = 'pg_catalog.english' # - Other Defaults - #explain_pretty_print = on #dynamic_library_path = '$libdir' #local_preload_libraries = '' #------------------------------------------------------------------------------ # LOCK MANAGEMENT #------------------------------------------------------------------------------ #deadlock_timeout = 1s #max_locks_per_transaction = 64 # min 10 # (change requires restart) # Note: Each lock table slot uses ~270 bytes of shared memory, and there are # max_locks_per_transaction * (max_connections + max_prepared_transactions) # lock table slots. #------------------------------------------------------------------------------ # VERSION/PLATFORM COMPATIBILITY #------------------------------------------------------------------------------ # - Previous PostgreSQL Versions - #add_missing_from = off #array_nulls = on #backslash_quote = safe_encoding # on, off, or safe_encoding #default_with_oids = off #escape_string_warning = on #regex_flavor = advanced # advanced, extended, or basic #sql_inheritance = on #standard_conforming_strings = off #synchronize_seqscans = on # - Other Platforms and Clients - #transform_null_equals = off #------------------------------------------------------------------------------ # CUSTOMIZED OPTIONS #------------------------------------------------------------------------------ #custom_variable_classes = '' # list of custom variable class names [/code] Chciałbym zapytać co jeszcze można zmienić aby ten postgrest szybciej odpowiadał ? Postgrest stoi na serwerze Hp dl380 ma on 8 GB ramu (docelowo 16 GB) i dyski sasowe]]> Mon, 30 Aug 2010 17:52:46 +0000 http://forum.postgresql.org.pl/viewtopic.php?id=476&action=new http://forum.postgresql.org.pl/viewtopic.php?id=478&action=new Mon, 30 Aug 2010 17:50:40 +0000 http://forum.postgresql.org.pl/viewtopic.php?id=478&action=new http://forum.postgresql.org.pl/viewtopic.php?id=480&action=new Thu, 26 Aug 2010 08:23:07 +0000 http://forum.postgresql.org.pl/viewtopic.php?id=480&action=new http://forum.postgresql.org.pl/viewtopic.php?id=479&action=new Wed, 25 Aug 2010 09:26:35 +0000 http://forum.postgresql.org.pl/viewtopic.php?id=479&action=new http://forum.postgresql.org.pl/viewtopic.php?id=477&action=new Sun, 22 Aug 2010 14:48:46 +0000 http://forum.postgresql.org.pl/viewtopic.php?id=477&action=new http://forum.postgresql.org.pl/viewtopic.php?id=475&action=new Tue, 10 Aug 2010 17:00:46 +0000 http://forum.postgresql.org.pl/viewtopic.php?id=475&action=new http://forum.postgresql.org.pl/viewtopic.php?id=474&action=new Tue, 10 Aug 2010 08:29:13 +0000 http://forum.postgresql.org.pl/viewtopic.php?id=474&action=new http://forum.postgresql.org.pl/viewtopic.php?id=472&action=new Mon, 09 Aug 2010 20:30:36 +0000 http://forum.postgresql.org.pl/viewtopic.php?id=472&action=new http://forum.postgresql.org.pl/viewtopic.php?id=332&action=new Sat, 07 Aug 2010 13:37:45 +0000 http://forum.postgresql.org.pl/viewtopic.php?id=332&action=new http://forum.postgresql.org.pl/viewtopic.php?id=473&action=new Sat, 07 Aug 2010 03:31:27 +0000 http://forum.postgresql.org.pl/viewtopic.php?id=473&action=new http://forum.postgresql.org.pl/viewtopic.php?id=176&action=new Fri, 06 Aug 2010 13:01:21 +0000 http://forum.postgresql.org.pl/viewtopic.php?id=176&action=new http://forum.postgresql.org.pl/viewtopic.php?id=470&action=new Sun, 25 Jul 2010 20:26:16 +0000 http://forum.postgresql.org.pl/viewtopic.php?id=470&action=new