Re: [PERFORM] How to configure the postgresql.conf files
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 [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > > > ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [PERFORM] How to configure the postgresql.conf files
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 [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > > > ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings