From: | "Chris_Wu" <Chris(dot)Wu(at)Sanmina-SCI(dot)Com> |
---|---|
To: | <pgsql-performance(at)postgresql(dot)org> |
Subject: | How to configure the postgresql.conf files |
Date: | 2003-07-14 03:26:37 |
Message-ID: | 000001c349b7$bc8b6280$660f19ac@ChrisWu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Rudi Starcevic | 2003-07-14 03:35:01 | Re: How to configure the postgresql.conf files |
Previous Message | Chris Bowlby | 2003-07-14 02:33:26 | Re: Improving a simple query? |