Обсуждение: 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 > > >