Thread: How to configure the postgresql.conf files
Hello all! I'm a new to Postgresql , I have never used it before. I am having an issue with configure the postgresql.conf file. The machine itself is a CPU= 2.66GHz P4 w/ Memory= 2G Maybe you can tell me how to configure these parameters. shared_buffers= max_fsm_relations= max_fsm_pages= max_locks_per_transaction= wal_buffers= sort_mem= vacuum_mem= wal_files= wal_sync_method= wal_debug = commit_delay = commit_siblings = checkpoint_segments = checkpoint_timeout = fsync = true enable_seqscan = enable_indexscan = enable_tidscan = enable_sort = enable_nestloop = enable_mergejoin = enable_hashjoin = ksqo = effective_cache_size = random_page_cost = cpu_tuple_cost = cpu_index_tuple_cost = cpu_operator_cost = Would you mind to send me a copy of examples .(postgresql.conf) Thanks Sincerely, Chris.Wu
Hi Chris, I suggest you read this tech. document: http://www.varlena.com/GeneralBits/ I think you'll it's the best place to start. Cheers Rudi. Chris_Wu wrote: >Hello all! > I'm a new to Postgresql , I have never used it before. > I am having an issue with configure the postgresql.conf file. > The machine itself is a > CPU= 2.66GHz P4 w/ > Memory= 2G > Maybe you can tell me how to configure these parameters. > shared_buffers= > max_fsm_relations= > max_fsm_pages= > max_locks_per_transaction= > wal_buffers= > sort_mem= > vacuum_mem= > wal_files= > wal_sync_method= > wal_debug = > commit_delay = > commit_siblings = > checkpoint_segments = > checkpoint_timeout = > fsync = true > enable_seqscan = > enable_indexscan = > enable_tidscan = > enable_sort = > enable_nestloop = > enable_mergejoin = > enable_hashjoin = > ksqo = > effective_cache_size = > random_page_cost = > cpu_tuple_cost = > cpu_index_tuple_cost = > cpu_operator_cost = > > Would you mind to send me a copy of examples .(postgresql.conf) > Thanks > Sincerely, > >Chris.Wu > > > >---------------------------(end of broadcast)--------------------------- >TIP 3: 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 > > >
Chris, Oops - it's changed ! Here's the link's you need: http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html Cheers Rudi. Chris_Wu wrote: >Hello all! > I'm a new to Postgresql , I have never used it before. > I am having an issue with configure the postgresql.conf file. > The machine itself is a > CPU= 2.66GHz P4 w/ > Memory= 2G > Maybe you can tell me how to configure these parameters. > shared_buffers= > max_fsm_relations= > max_fsm_pages= > max_locks_per_transaction= > wal_buffers= > sort_mem= > vacuum_mem= > wal_files= > wal_sync_method= > wal_debug = > commit_delay = > commit_siblings = > checkpoint_segments = > checkpoint_timeout = > fsync = true > enable_seqscan = > enable_indexscan = > enable_tidscan = > enable_sort = > enable_nestloop = > enable_mergejoin = > enable_hashjoin = > ksqo = > effective_cache_size = > random_page_cost = > cpu_tuple_cost = > cpu_index_tuple_cost = > cpu_operator_cost = > > Would you mind to send me a copy of examples .(postgresql.conf) > Thanks > Sincerely, > >Chris.Wu > > > >---------------------------(end of broadcast)--------------------------- >TIP 3: 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 > > >