Folks,

Last we talked (before the mail server went down) Tom had agreed in principle 
to a re-ordering of postgresql.conf.sample and the "Run-Time Configuration" 
docs page based on the attached ordering file.

I would like to make this happen before feature-freeze on June 15.   To do 
that, I need more info:

1) Are any additional changes expected for GUC.c before feature-freeze?

2) Are all of the new GUC.c variables for 7.4 already documented in the CVS 
docs?  If not, can the responsible parties send me descriptions so that I can 
doc it?

3) Do people want me to take a stab at re-ordering GUC.c as well (that is, 
Tom's idea of having the GUC.c ordering alphabetical within each variable 
type), considering that I am not a C programmer?

4) Does anyone else have any comments on the proposed re-ordering?

-- 
Josh Berkus
Aglio Database Solutions
San Francisco
#CONNECTIONS AND AUTHENTICATION
        #Connection Settings
                tcpip_socket
                max_connections
                superuser_reserved_connections
                port
                unix_socket_directory
                unix_socket_group
                unix_socket_permissions
        #Security & Authentication
                ssl
                authentication_timeout
                virtual_host
                krb_server_keyfile
                db_user_namespace


#RESOURCE USAGE (except WAL)
        #Memory
                shared_buffers
                sort_mem
                vacuum_mem
        #Free Space Map
                max_fsm_relations
                max_fsm_pages
        #Disk Usage
                max_files_per_process


#WRITE AHEAD LOG
                fsync
                wal_sync_method
                wal_buffers
                checkpoint_segments
                checkpoint_timeout
                commit_delay
                commit_siblings
                wal_debug

#QUERY TUNING
        #Join Methods
                enable_seqscan
                enable_indexscan
                enable_tidscan
                enable_sort
                enable_nestloop
                enable_mergejoin
                enable_hashjoin
        #Planner Cost Constants
                effective_cache_size
                random_page_cost
                cpu_tuple_cost
                cpu_index_tuple_cost
                cpu_operator_cost
                default_statistics_target
        #Genetic Estimate Query Optimizer
                geqo
                geqo_threshold
                geqo_selection_bias
                geqo_pool_size
                geqo_effort
                geqo_generations
                geqo_random_seed
        #Other
                explain_pretty_print
                max_expr_depth
                

#CLIENT CONNECTION DEFAULTS
        #Statement Behaviour
                autocommit
                search_path
                default_transaction_isolation
                statement_timeout
        #Locale and Formatting
                datestyle
                timezone
                australian_timezones
                client_encoding
                lc_messages
                lc_monetary
                lc_time
                lc_numeric
        #Other Defaults
                dynamic_library_path
                password_encryption


#LOGGING & DEBUGGING
        #Debugging/Logging Levels
                server_min_messages
                client_min_messages
                log_min_error_statement
                debug_print_parse
                debug_print_rewritten
                debug_print_plan
                debug_pretty_print
                debug_assertions
                silent_mode
        #Additional Info to Log
                log_connections
                log_pid
                log_statement
                log_duration
                log_timestamp
                hostname_lookup
                show_source_port
        #Syslog
                syslog
                syslog_facility
                syslog_ident


#STATISTICS
        #Statistics monitoring
                show_parser_stats
                show_planner_stats
                show_executor_stats
                show_statement_stats
        #Query/Index Statistics Collector
                stats_start_collector
                stats_reset_on_server_start
                stats_command_string
                stats_row_level
                stats_block_level


#LOCK MANAGEMENT
                max_locks_per_transaction
                deadlock_timeout


#VERSION COMPATIBILITY OPTIONS
                sql_inheritance
                transform_null_equals






---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to