From: | Rudi Starcevic <rudi(at)oasis(dot)net(dot)au> |
---|---|
To: | Chris(dot)Wu(at)Sanmina-SCI(dot)Com |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: How to configure the postgresql.conf files |
Date: | 2003-07-14 03:46:51 |
Message-ID: | 3F1227AB.2060400@oasis.net.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Shridhar Daithankar | 2003-07-14 06:37:32 | Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL |
Previous Message | Rudi Starcevic | 2003-07-14 03:35:01 | Re: How to configure the postgresql.conf files |